Office Settings & Configuration

Fix Access Combo Box Not Displaying Existing Filtered Values

Huda Qurayshi Sep 25, 2026 869 views

Question details

An Access form's filtered combo box fails to display names for existing records if the stored staff ID belongs to a former employee or someone outside the current filter criteria.

Fix Access Combo Box Not Displaying Existing Filtered Values

Product: Microsoft Access
Device & OS: not provided
Scenario: Viewing or navigating existing records in a Microsoft Access form that uses a dynamically filtered combo box for employee selection.
Observed behavior: The combo box appears entirely blank for certain historical records, even though the correct staff ID is saved in the underlying table.

Before you start

Before modifying your form's design or VBA code, ensure you have a backup of your Access database. If you are using a downloaded sample database to test fixes, make sure the file is saved in a Trusted Location.

Solution 1Recommended

Update the Row Source to Include Stored Values

Modify the combo box's Row Source query to include both the currently filtered employees and the specific employee stored in the existing record.

A combo box fundamentally cannot display a value that is missing from its Row Source. When you filter a combo box to show only 'active' or 'current' employees, older records containing 'inactive' employees will appear blank. To fix this, you must expand the SQL query.

Open Form in Design View

Right-click your form in the navigation pane and select 'Design View'.

Edit the Row Source

Select the problematic combo box, press F4 to open the Property Sheet, navigate to the 'Data' tab, and click the ellipsis (...) next to 'Row Source'.

Modify the SQL Query

Adjust your query using an OR condition or a UNION statement to explicitly include the employee ID bound to the current record, regardless of their active status.

Requery on Record Change

Navigate to the form's 'Event' tab in the Property Sheet, click 'On Current', and add a brief VBA macro to requery the combo box (e.g., Me.YourComboBoxName.Requery) so it updates during navigation.

Update the Row Source to Include Stored Values

Requery Requirement: It is essential to requery the combo box on the form's On Current event, otherwise, the dynamically injected existing value will not refresh when you navigate between different records.

Solution 2

Use Separate Controls for Display and Data Entry

Bypass the filtering limitation entirely by using a standard text box to display the name and reserving the filtered combo box only for changing data.

Solution 3

Unblock Downloaded Database Files

If you downloaded an Access database to study this solution and it throws compile errors or hides data, you need to clear Microsoft's Mark of the Web restrictions.

Free Microsoft Office alternative

Simplify Data Management with WPS Office

While Microsoft Access is powerful for relational database design, many complex UI configuration issues can be avoided by managing everyday lists and datasets in a robust spreadsheet environment. WPS Office provides a free, lightweight, and highly compatible alternative for your document, spreadsheet, and presentation needs, complete with familiar data validation tools.

1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your device.
2. Import Your Data: Launch WPS Spreadsheet and easily open or import your exported Access tables, Excel files, or CSV datasets.
3. Setup Data Validation: Use the Data Validation tool in the Data ribbon to create reliable, unfiltered dropdown lists that won't hide your existing entries.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formatsLightweight suite that installs quickly and runs smoothly on all PCsFree to use with a familiar, intuitive UI, making migration seamlessEasily recreate dropdown lists and relational data using Data Validation and VLOOKUP

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access combo box appear blank when I know the data is in the table?

An Access combo box will appear blank if the underlying bound value (like a Staff ID) exists in the table, but that specific value has been filtered out or is otherwise missing from the combo box's Row Source property.

How do I fix macros being disabled in a downloaded Access database?

To fix this, close the file, right-click it in File Explorer, select Properties, and check the 'Unblock' box. Afterward, move the file to a Trusted Location defined in your Access Trust Center before opening it again.

Can I display an employee name but store their ID using an Access combo box?

Yes. Set the combo box's Column Count property to 2 and set the Bound Column to 1 (assuming the ID is the first column). Then, under the Format tab, set the Column Widths to '0cm;3cm' to hide the ID and display only the name.

Office App Problems