Fix an Access 2013 Combo Box That Stops Finding Records
Question details
Restore a combo box's ability to find matching records after an Access database is reopened.

- 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.
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.
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.
Right-click the affected form in the Navigation Pane, select Design View, and click the combo box. Press F4 to open its Property Sheet.
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.
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.
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.
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 whether Access has blocked database content
Use this check if the combo box relies on a macro or VBA event that does not run after the database is reopened.
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.

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.




