Others

Use a Combo Box Value as Query Criteria in Microsoft Access

Huma Ashraf ChHuma Ashraf Ch Nov 14, 2026 868 views

Question details

Use a selected combo box value to filter customer records in an Access query.

Use a Combo Box Value as Query Criteria in Microsoft Access
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.
Before you start

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.

Solution 1Recommended

Reference the form control directly in the query criteria

Use the open form's combo box value to filter the matching query field.

1
Open the query in Design View

In the Navigation Pane, right-click the customer query and select Design View.

2
Enter the control reference

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.

3
Run the query

Keep the Top100Cust form open with a value selected in Combo110, then click Run on the Query Design ribbon.

4
Check the bound value

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.

Reference the form control directly in the query criteria
Use customer IDs for reliable matches: Customer names may not be unique. Where possible, match a customer primary key to the corresponding foreign key rather than filtering by name.
Free Microsoft Office alternative

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.

Filter and review exported customer lists in WPS Spreadsheets.Open and edit Microsoft Excel XLSX files for an easy spreadsheet transition.Use a familiar interface for common spreadsheet tasks.Work with a free, lightweight office suite.
microsoft office alternative - wps office

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.