Fix Microsoft Access Report Showing Blank When Opened via Combo Box
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).

- 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.
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.
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.
Navigate to the Navigation Pane, right-click the query that powers your report, and select 'Design View'.
Find the column representing the unique identifier (e.g., StaffID) that corresponds to the bound column of your form's combo box.
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).
Check the 'Staff Name' column in the query grid and delete any form references in its 'Criteria' row to prevent conflicting filters.
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.

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. Download WPS Office: Get the free WPS Office suite from the official website and run the lightweight installer.
- 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. 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.

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.




