Office Settings & Configuration

Fix an Access 2013 Combo Box That Stops Finding Records

Huma Ashraf ChHuma Ashraf Ch Nov 14, 2026 868 views

Question details

Restore a combo box's ability to find matching records after an Access database is reopened.

Fix an Access 2013 Combo Box That Stops Finding Records
Product
Microsoft Access 2013
Device & OS
not provided
Scenario
A combo box created with the wizard is used to find records on a form in a new database.
Observed behavior
The combo box finds matching records when first created, but no longer does so after the database is saved, closed, and reopened. Older databases are not affected.
Before you start

Reopen the affected database and note whether typing fails to suggest a match or selecting a value fails to move the form to the matching record. Have an older working database available for comparison, and note any security warning or error message.

Solution 1Recommended

Check the combo box properties and search event

Use Design view to verify that the reopened control still has the correct data source and record-search behavior.

A combo box can suggest entries as you type and also run an event to find a record when you select an entry. Check the behavior that has stopped working.

1
Open the property sheet

Right-click the affected form in the Navigation Pane, select Design View, and click the combo box. Press F4 to open its Property Sheet.

2
Review the row source

On the Data tab, check Row Source and open its query with the build button if needed. Confirm that it returns the intended values and fields; compare it with a working combo box.

3
Check the bound column and suggestions

On the Data tab, check Bound Column to confirm the selected value comes from the intended column. On the Format tab, check Column Widths and set Auto Expand to Yes if you want matching entries suggested as you type.

4
Inspect the search event

On the Event tab, check After Update for an embedded macro or event procedure. Use the build button to inspect it and compare its record-search field and logic with those in a working database.

5
Save and retest

Save the form, close and reopen the database, then open the form in Form View. Type a matching value and select it to test both suggestions and record navigation.

Check the combo box properties and search event
The cause is not yet confirmed: Property differences or a missing search event may explain the behavior, but an error message or a comparison with a working database may be needed to identify the cause.
Free Microsoft Office alternative

Use WPS Office for Everyday Documents and Spreadsheets

WPS Office is a free, lightweight alternative for working with familiar Office documents and spreadsheets. Its familiar interface and Microsoft Office format compatibility make it easy to move everyday files, but it does not repair Access combo boxes or replace Access databases.

Work with tables and filters in WPS SpreadsheetOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar interface for common document and spreadsheet tasksMove compatible Office files into a lightweight, free office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does the combo box list values but not move to a record?

The list can work independently of the record-search event. In the form's Design View, select the combo box, press F4, and inspect After Update on the Event tab for a macro or event procedure.

How do I make the combo box suggest matches as I type?

In Design View, select the combo box and open its Property Sheet with F4. On the Format tab, set Auto Expand to Yes, then test the control in Form View.

Can a security warning prevent the search from working?

Yes. If the search relies on a macro or VBA event, blocked database content can prevent it from running. After reopening the database, check the security warning and enable content only if you trust the file.

What should I compare with an older working database?

Open both forms in Design View and compare the combo boxes' Row Source, Bound Column, Column Widths, Auto Expand, and After Update settings. Also check which field the search event uses.