Combo Boxes

[Jeff_Ford]

I want a combo boxes values to be based upon the selection made in a previous combo box.

I.E the first combo box displays customer names and based upon the selction of the company name the next combo box will be populated with the parts made by that customer.

I have created tables with the part names in and named them by customer.

I assume this is the correct wat to do it? Then on the "on Exit property" of the first textbox i must need to say something similar to:

Private Sub Customer_Selector_Exit(Cancel As Integer)
If Customer_Selector.Value = "GM" Then
Part_Selector.RowSource = SELECT GM.ID FROM GM;
End Sub

Can anybody help me please?

 

[Hayley Baxter]

I posted an example of how to do this in this thread

If you're still having problems post up your db.

 

[namliam]

Funny how no one ever seems to find an answer to the same question