Others

How to Fix an Access Combo Box That Does Not Populate

Tauseeq Magsi Oct 10, 2026 868 views

Question details

The user needs to fix a combo box on a form that appears blank when configured to display manager names instead of user IDs.

How to Fix an Access Combo Box That Does Not Populate

Product: Microsoft Access
Device & OS: not provided
Scenario: Selecting a manager's name from a drop-down combo box on a form built from a query.
Observed behavior: The combo box works correctly in Datasheet view but displays as entirely blank on the form when the query is modified to show only text names.

Before you start

Ensure you have Design View access to your database forms and verify that your tables have properly defined primary and foreign keys.

Solution 1Recommended

Use a Foreign Key and Configure Bound Columns

Fix the blank combo box by storing the Manager ID as a numerical foreign key while hiding the ID column to only display the manager's name.

A common mistake in Access database design is attempting to store text names directly in the table to make a combo box display correctly. Instead, you should store the unique Employee ID (as a Manager ID foreign key) and adjust the combo box properties to hide the ID and show the concatenated text names.

Open Form Design View

Right-click your form in the navigation pane and select Design View, then click on the malfunctioning combo box.

Set the Row Source Query

In the Property Sheet, go to the Data tab. Change the Row Source to an SQL query that pulls both the ID and the Name, such as: SELECT EmployeeID, LastName & ', ' & FirstName FROM Employees ORDER BY LastName, FirstName;

Configure the Bound Column

Still on the Data tab, set the Bound Column property to 1. This ensures that Access stores the numerical EmployeeID rather than the text name.

Adjust Column Count and Widths

Switch to the Format tab in the Property Sheet. Set the Column Count to 2. Then, set the Column Widths to 0";1.5". The 0" width hides the first column (the ID), causing the combo box to display the second column (the names).

Use a Foreign Key and Configure Bound Columns

Database Best Practice: Storing numerical IDs rather than text strings prevents update anomalies, improves query performance, and keeps your database properly normalized.

Free Microsoft Office alternative

Need a Free Office Suite for Your Data Exports? Try WPS Office

While WPS Office does not include a direct Microsoft Access equivalent, it is an exceptional free alternative for managing data exports, creating reports, and handling everyday office tasks. If you export Access queries to Excel, WPS Spreadsheet offers powerful data analysis tools that feel instantly familiar.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Seamlessly open, analyze, and chart database exports using WPS Spreadsheet.Lightweight installation with an intuitive, all-in-one tabbed workspace.Completely free to download and use for your daily productivity needs.

Frequently Asked Questions

Why does my Access combo box show numbers instead of names?

This happens when the Bound Column is set to the ID, but the Column Widths property is not configured to hide the ID column. To fix this, open the Property Sheet for the combo box, navigate to the Format tab, and set the first column width to 0".

How can I filter the combo box to show only managers?

You can modify the Row Source SQL query of the combo box by adding a WHERE clause. For example, add 'WHERE IsManager = True' before the 'ORDER BY' clause to restrict the drop-down list to employees marked as managers.

Can I exclude the current employee from the manager drop-down list?

Yes. You can exclude the current record by referencing the form's active ID in the Row Source query. Add a condition like 'WHERE EmployeeID <> Forms!YourFormName!EmployeeID' to prevent an employee from being assigned as their own manager.

Office Quick Solutions