How to Fix Microsoft Access Autofill After Renaming a Database
Question details
The user needs to restore the autofill functionality in a Microsoft Access database that stopped working after the database file was renamed.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- The database file name was changed, resulting in forms failing to automatically fill in related record information.
- Observed behavior
- Autofill features no longer populate related fields. This is typically caused by broken form record sources, misconfigured queries, or VBA code explicitly referencing the old file name, rather than the file name change itself.
Before modifying your database structure or code, create a complete backup copy of the current database to prevent accidental data loss during troubleshooting.
Update Form Record Sources and Relational Queries
Check and repair the underlying queries and record sources that power the form's autofill capabilities.
Autofill functions usually rely on queries joining multiple tables. If a database is restructured or renamed, you must ensure that forms are correctly bound to a query that links primary IDs to related data (e.g., linking a CustomerID to retrieve the customer name).
Right-click the problematic form in the Navigation Pane and select 'Design View'.
Press F4 to open the Property Sheet. Under the 'Data' tab, locate the 'Record Source' field and click the builder button (...) to open the Query Builder.
Ensure the primary table is correctly joined to the related table (e.g., Demographics) via the relevant ID field, allowing the query to retrieve related data without duplicating fields.
If you use combo boxes for autofill, check their 'Row Source' property to ensure they are querying the correct updated tables.

Check VBA Code and Linked Tables
Fix broken file path references in VBA modules and update the Linked Table Manager if your database is split.
Looking for a Lightweight Alternative to Microsoft Office?
While Microsoft Access handles complex relational databases, managing lists, reports, and related data can often be done more easily using advanced spreadsheets. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for your data management and daily document needs.
- 1. Download WPS Office: Visit the official WPS website to download and install the free productivity suite.
- 2. Export Database Records: In your database application, export your tables or queries as Excel (.xlsx) files.
- 3. Manage Relational Data in WPS: Open the exported files in WPS Spreadsheet and easily link data across different sheets using lookup formulas.

Frequently Asked Questions
Why did my Microsoft Access autofill stop working after changing the file name?
Changing the database file name does not usually break internal form connections. However, it will cause failures if your database relies on linked tables, split front-end/back-end architecture, or VBA scripts that contain hardcoded references to the old file name.
Should I copy demographic fields into other tables to make autofill work?
No. Duplicating fields across multiple tables is considered poor database design and can lead to data inconsistencies. You should store demographics in a single, dedicated table and use queries, forms, or reports to join and display the related data.
What is the best way to display related data in Access forms?
The recommended approach is to use a main form bound to your primary table with a subform bound to the related table. Alternatively, you can use combo boxes that draw their row source from a query linking both tables.




