Dedicated Lookup Control
Just like a combo but without a drop down button and does not allow editing. It would be bound to a FK but display a selected column from the related table but not be editable and would not have a drop down button.
This would save having to add related tables to a form's record source when you only want to display a column. And you definitely don't want to allow the user to modify it.
An example would be on a continuous form bound to tblInvoice, The control is bound to tblInvoice.CustomerID but displays tblCustomer.CustomerName.
This could possibly be achieved by adding a property to ComboBox to remove the button and lock it (but not disable it so a user can still select the displayed content if they need to copy it to the clipboard).
