Bind Label to Table

[joopa]

All,
My form contains ComboBoxes for the user to pick records from a related table. I created them using the wizard, the option Lookup in Query or Table.

The ComboBoxes are getting quite long, so I created a button to a Subform where the user can scroll and find the record to insert.

I want to make a Label on my main form that shows Customer_Submitted from the selected record. It should be embedded and non-editable.???

In my ComboBox the following information is used:

Control Source: Customer_ID

Row Source:
SELECT Customer.Customer_ID, Customer.Submitted_By FROM Customer;


Hope it makes sense,

Thanks
JJ

 

[dcurtis]

Your idea was a little hard to follow. How are the users selecting the customer on the subform?