Combo box selection based on a different form

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?
 
I'm sorry, I have read the 2 guides you posted and I'm still at a loss (I don't have much experience programming with VB) :confused:

Could you give me an example of what the code would look like?
 

Users who are viewing this thread

Back
Top Bottom