How do I make a combo box with choices contingent on another fiel.

G

Guest

I am trying to create combo box on a form that shows the correct auto
"Models" based on what is chosen in the combo box "Makes". First I made a
"Makes" table that has "MakeID" as the primary key, then I made a "Models"
table with four fields: ModelID, ModelName, MakeID, MakeName. I have
populated that with the choices I would like users to have; however,
sometimes they may know the Make but not the Model of the car, so I can't
just cause "Model" to be populated based on "Make".
 
J

Jeff Boyce

Take a look in Access HELP, mvps.org, Google.com and/or this newsgroup under
the topic of "cascading combo boxes".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

synchronize combo boxes 7
synchronize combo boxes 1
How to design relationship between tables 1
combo box choices based on first combo box 7
How do I use one field to populate a Combo box in another field? 2
Combo box on a form 1
Combo Box 1
Combo box help 1

Top