jetersauce
Registered User.
- Local time
- Today, 09:38
- Joined
- Dec 21, 2010
- Messages
- 20
I have a form that has a combo box that selects CustomerIDs and displays the correct record in the subform. The row source for this combo box is a table named cbCustomerIDs that the only field is a list of all the CustomerIDs.
What I need is for the combo box to automatically select the CustomerID based on another form called Invoices. This form has a subform that lists all the tests and has a CustomerID field (this is the field that the combo box needs to match).
Question is how to make the combo box select the CustomerID based on the field on the form while leaving the row source as cbCustomerIDs?
What I need is for the combo box to automatically select the CustomerID based on another form called Invoices. This form has a subform that lists all the tests and has a CustomerID field (this is the field that the combo box needs to match).
Question is how to make the combo box select the CustomerID based on the field on the form while leaving the row source as cbCustomerIDs?