Others

Fix Microsoft Access Report Showing Blank When Opened via Combo Box

Camila MilosovichCamila Milosovich Nov 3, 2026 868 views

Question details

A Microsoft Access report fails to display data when launched from a form's combo box due to a mismatch between the query criteria (filtering by name) and the combo box's returned value (an ID).

How to Fix a Blank Access Report When Opened from a Form Combo Box
Product
Microsoft Access
Device & OS
not provided
Scenario
Launching a filtered report using a combo box selection on a Microsoft Access form.
Observed behavior
The report appears completely blank and returns no records when opened via the form, even though the report and query function normally when opened directly.
Before you start

Open your Microsoft Access database in Design View and verify the exact names of your form, your combo box, and the query that serves as the report's Record Source.

Solution 1Recommended

Update the Query Criteria to Filter by Staff ID

Modify the underlying query of the report to filter by the unique ID returned by the combo box, rather than the text-based name.

Combo boxes are often configured to display a text field (like a name) while binding to a hidden primary key (like a Staff ID). If your query searches for a text name but the form passes a numeric ID, the mismatch results in zero records.

Using unique IDs instead of names is a database best practice, as it prevents errors caused by duplicate names in your records.

1
Open the report query in Design View

Navigate to the Navigation Pane, right-click the query that powers your report, and select 'Design View'.

2
Locate the ID column

Find the column representing the unique identifier (e.g., StaffID) that corresponds to the bound column of your form's combo box.

3
Set the criteria reference

In the 'Criteria' row directly underneath the StaffID column, enter the exact form and combo box reference: [Forms]![YourFormName]![YourComboBoxName] (replace with your actual object names).

4
Remove the incorrect name filter

Check the 'Staff Name' column in the query grid and delete any form references in its 'Criteria' row to prevent conflicting filters.

5
Save and verify

Save the query, open your form in Form View, select a name from the combo box, and click your button to open the report. The data should now populate correctly.

Update the Query Criteria to Filter by Staff ID
Database Best Practice: Always use a primary key (like StaffID) as a foreign key in related tables. Storing and filtering by text names can lead to inaccurate reports if two employees share the same last name.
Free Microsoft Office alternative

Manage Data efficiently with WPS Office Spreadsheet

While Microsoft Access is designed for complex relational databases, many users find that day-to-day data tracking, filtering, and reporting can be accomplished much more easily using spreadsheets. WPS Spreadsheet offers a powerful, intuitive, and highly compatible alternative to Excel for managing lists, generating reports, and analyzing data without database programming.

  1. 1. Download WPS Office: Get the free WPS Office suite from the official website and run the lightweight installer.
  2. 2. Import your Access data: Export your Microsoft Access tables or queries to Excel or CSV format, then open them directly in WPS Spreadsheet.
  3. 3. Generate reports easily: Highlight your dataset, go to the Insert tab, and select PivotTable to dynamically filter, summarize, and report on your staff data without writing SQL or VBA.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Advanced filtering and PivotTables for effortless data reporting without complex queries.Free, lightweight, and fast installation on Windows, Mac, and Linux systems.Familiar tabbed interface ensuring a seamless transition and zero learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my combo box return a number instead of the name I selected?

By default, Access combo boxes generated by wizards bind to the first column (usually the primary key or ID) while setting its width to 0 to hide it. It displays the second column (the name). The bound column, however, is the actual value passed to your queries and macros.

How do I find the exact name of my form and combo box?

Open your form in Design View, click on the combo box, and press F4 to open the Property Sheet. Look at the top of the Property Sheet or under the 'Other' tab for the 'Name' property. Ensure you use this exact name in your query criteria.

Can I filter an Access report without modifying the query criteria?

Yes. Instead of changing the query, you can use VBA on the form button's On Click event. Use the DoCmd.OpenReport method with a WHERE condition string, such as: DoCmd.OpenReport "ReportName", acViewPreview, , "StaffID = " & Me.cboName.

What happens if I continue filtering my reports by staff name?

If you filter by a non-unique field like a staff name, your report will group and display records for all employees sharing that exact name. This leads to mixed data and inaccurate reporting. Always use unique identifiers for database filters.