dependent combobox

It is possible, and not all that difficult. But can you tell us a bit about your tables? You say select a customer from a combobox and then have all contacts from that company appear in the second combobox. Does the rowsource of the first combo contain customer AND company? Also, do you have a separate table with contacts, and is company also in that table?

Thank you,

Russell

Hi Russell,

I have two tables, one with customer details and the other with customer contact details. Both tables have the customer ID in them. The company details that I was referring to is the customer contact details for that customer, I should not have said company, sorry.

Regards,

Bill

So when you select the customer in one combo, you want the details in the other one? And the contact details has multiple rows per ID?

Hi Russell,

What I have is a table for Sales Orders, joined to the Customers table by the CustomerID field. Then the Customers table is joined to the CustomersContacts by the CustomerContactID. Each Customer can have many sales orders and each customer can have many CustomerContacts.
Ideally, I would like to select a new Sales Order and Customer from a ComboBox and for the CustomerContact combobox to have all of the records from that customer.

I hope this clarifies it a little, Russell.

Regards,

Bill

What I have is a table for Sales Orders, joined to the Customers table by the CustomerID field. Then the Customers table is joined to the CustomersContacts by the CustomerContactID. Each Customer can have many sales orders and each customer can have many CustomerContacts.
Ideally, I would like to select a new Sales Order and Customer from a ComboBox and for the CustomerContact combobox to have all of the records from that customer.

Click to expand...

Ok, not sure what field you want to have in your second combobox, but basically you can base the Row Source of the second combobox on the first, something like:

Select [CustomerContact] From CustomerContacts Where [CustomerID] IN ([Forms]![FormName]![FirstComboName])

Then, add some code to the AfterUpdate event of the first cobmbobox, something like:<pre>Private Sub cboCompany_AfterUpdate()
Me.cboContacts.Requery
Me.cboContacts = Me.cboContacts.ItemData(0)
End Sub</pre>

And you can add something like this to the Form's Load or Open event so that you have a value in the first combo upon opening:<pre>Private Sub Form_Load()
Me.cboCompany = Me.cboCompany.ItemData(0)
End Sub</pre>

HTH,

Russell
This message was edited by Russell Hauf on 2003-01-17 11:57

Hi Russell,

Thanks again, that worked perfectly.

Regards,

Bill