Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
ACC2000: Base Combo Box on Parameter Query to Filter Values
Article ID: 209542 - View products that this article applies to.
This article was previously published under Q209542
This article applies only to a Microsoft Access database (.mdb).
Moderate: Requires basic macro, coding, and interoperability skills.
This article shows you how to filter values that appear in a combo box by basing the combo box on a parameter query.
Sometimes, you may want to limit the values that appear in a combo box. For example, you may want to show only suppliers whose names begin with a certain letter. Although Access does not allow filters on combo boxes, if you base your combo box on a parameter query, you can filter the values by using a criteria clause.
To create a combo box that displays only the suppliers that meet the criteria that you specify, follow these steps.
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
For more information about creating combo boxes, click Microsoft Access Help on the Help menu, type creating and editing combo boxes in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
For more information about creating criteria queries, click Microsoft Access Help on the Help menu, type creating criteria queries in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.