Office Settings & Configuration

How to Fix Microsoft Access Autofill After Renaming a Database

Rana GarciaRana Garcia Nov 3, 2026 868 views

Question details

The user needs to restore the autofill functionality in a Microsoft Access database that stopped working after the database file was renamed.

How to Fix Microsoft Access Autofill After Renaming a Database
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 you start

Before modifying your database structure or code, create a complete backup copy of the current database to prevent accidental data loss during troubleshooting.

Solution 1Recommended

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).

1
Open the Form in Design View

Right-click the problematic form in the Navigation Pane and select 'Design View'.

2
Access the Record Source Property

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.

3
Verify Table Joins

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.

4
Update Combo Boxes

If you use combo boxes for autofill, check their 'Row Source' property to ensure they are querying the correct updated tables.

Update Form Record Sources and Relational Queries
Database Design Best Practice: Do not copy demographic information into event tables (like falls or abuse). Store demographics in one dedicated table and use queries, subforms, or combo boxes to display this information together.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download and install the free productivity suite.
  2. 2. Export Database Records: In your database application, export your tables or queries as Excel (.xlsx) files.
  3. 3. Manage Relational Data in WPS: Open the exported files in WPS Spreadsheet and easily link data across different sheets using lookup formulas.
Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Free and lightweight, consuming minimal system resources compared to heavy database suites.Familiar user interface allows for a seamless transition with no steep learning curve.Built-in advanced spreadsheet functions (like XLOOKUP and VLOOKUP) to handle relational data efficiently without complex VBA coding.
microsoft office alternative - wps office

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.