Use a Combo Box Value as Query Criteria in Microsoft Access
Question details
Use a selected combo box value to filter customer records in an Access query.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A query should return customer records matching the value selected in a form's combo box.
- Observed behavior
- The query may return no records when the form control reference is entered incorrectly.
Open the Top100Cust form and select a value in Combo110. Check the form and control names in their property sheets, and identify the query field that should match the combo box's bound value.
Reference the form control directly in the query criteria
Use the open form's combo box value to filter the matching query field.
In the Navigation Pane, right-click the customer query and select Design View.
In the Criteria row under the field to filter, enter Forms![Top100Cust]![Combo110] directly, replacing the names if your form or control uses different names.
Keep the Top100Cust form open with a value selected in Combo110, then click Run on the Query Design ribbon.
If the query still returns no records, open the form in Design View, select Combo110, and check Bound Column and Row Source in the Property Sheet. Make sure the bound value matches the query field's data type and stored values.

Work with exported customer lists in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface. Export Access customer data to a spreadsheet to work with it in WPS; WPS does not run Access database queries or forms.

Frequently Asked Questions
What should I enter in the query Criteria row?
In Query Design View, enter Forms![Top100Cust]![Combo110] in the Criteria row under the field you want to filter. Use your actual form and combo box names if they differ.
Does the form need to be open when I run the query?
Yes. Open Top100Cust and select a value in Combo110 before running a query that refers to that control.
Why does the query return no records even though a customer is selected?
The combo box's bound value may differ from the displayed name. In the form's Design View, check the control's Bound Column and Row Source properties, then compare the bound value with the query field's type and stored values.
Should I filter by customer name or customer ID?
Prefer a customer ID when possible: names may be duplicated, while a primary key identifies a customer uniquely. Match that key to the appropriate foreign key in related records.




