Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:


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


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.

share|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:… – David W. Fenton Apr 6 '10 at 0:33

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.