Combo Boxes

[wrens_splein]

Hi hope someone can help out there
I am using Access 2000.
What I am trying to achieve on a form is the following:

One combo box displays a list manufacturers, when the user selects a manufacturer it then populates the next combo box with all models relating to that manufacturer.

I have managed to get it to work but not 100% successful by using a SQL Query.

I have created all the relationships for the tables and they are fine.

Any thoughts on this would greatly appreciated

 

[IMO]

Do a search here for "cascading combo boxes", there are hundreds of posts covering your question and some good examples too. Post back if you still need help.

IMO