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.

  • 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! Apr 3, 2010 at 22:38
  • Also, have you seen this StackOverflow question: stackoverflow.com/questions/2560060/… Apr 6, 2010 at 0:33


You must log in to answer this question.

Browse other questions tagged .