Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

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: stackoverflow.com/questions/2560060/… –  David W. Fenton Apr 6 '10 at 0:33

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.