up vote 0 down vote favorite
share [g+] share [fb]

What's the most efficient way to "chain" combo/boxes in an Access 2007 form, so that the result of the first affected the contents of the second? I already know how to associate a combo box on a form with a query.

Here's a example of my scenario:

cmbCarMake

Behavior: User starts typing, and list shows all manufacturers in a table starting with those characters (e.g., "Ford")

cmbCarModel

Behavior: Once cmbCarMake has a selected a Make, this object will limit the possible models the user can search for by only displaying models from that one manufacturer. (e.g., "F-150")

Thank you for any examples/links.

link|improve this question
Have you Googled on "Access cascading combo box"? If not, why not? If you had, you'd have plenty of explanations of the usual solutions to this problem, as it's one of the most common Access questions. Certainly once you've looked at those, you may have questions, and we'll be glad to help, but please, first do your homework! – David W. Fenton Apr 3 '10 at 22:38
Also, have you seen this StackOverflow question: stackoverflow.com/questions/2560060/… – David W. Fenton Apr 6 '10 at 0:33
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.