Others

How to Restore Missing Data in Microsoft Access Subforms

Tauseeq Magsi Oct 10, 2026 869 views

Question details

The user needs to retrieve data that has disappeared from Microsoft Access subforms but is still returning correctly in the underlying queries.

How to Restore Missing Data in Microsoft Access Subforms

Product: Microsoft Access
Device & OS: not provided
Scenario: Viewing existing records or entering new data via a master-detail form in a Microsoft Access database.
Observed behavior: Records are missing or invisible in the subform interface, even though the data continues to exist unharmed in the underlying tables and queries.

Before you start

Before modifying form properties, verify that your underlying queries and tables still contain the expected records, and ensure you have a recent backup of your Access database.

Solution 1Recommended

Remove Active Form or Subform Filters

Often, data appears missing simply because a filter has been accidentally applied, hiding the records from view.

Microsoft Access forms remember filter settings, which can sometimes persist between sessions. Removing these filters restores visibility to all underlying data.

Locate Navigation Buttons

Look at the bottom of your Access form or subform for the record navigation bar.

Identify Filter Status

Check if the word 'Filtered' is highlighted or visible next to the navigation buttons.

Clear the Filter

Click on the 'Filtered' button to toggle it to 'Unfiltered', or go to the Home tab on the Ribbon and click 'Advanced' > 'Clear All Filters'.

Tip: If you frequently encounter this issue, you can set the 'Filter On Load' property of the form to 'No' in Design View.

Solution 2

Verify Link Master and Link Child Fields

Incorrect master-child relationships can prevent the subform from loading the matching records associated with the main form.

Solution 3

Disable the Data Entry Property

If a form is set specifically to 'Data Entry' mode, it hides all historical records and only allows the addition of new ones.

Free Microsoft Office alternative

Experience a Free and Lightweight Alternative to Microsoft Office

While Microsoft Access handles complex database management, WPS Office is the perfect free Microsoft Office alternative for managing your daily documents, spreadsheets, and presentations. Enjoy a familiar interface with extensive format compatibility, absolutely free.

1. Download the Installer: Visit the official WPS Office website and click the free download button for your specific operating system (Windows, Mac, Linux, or Mobile).
2. Install WPS Office: Run the downloaded installer and follow the simple on-screen instructions to complete the setup in minutes.
3. Open Your Office Files: Launch WPS Office and directly open your existing Word, Excel, or PowerPoint files without losing any formatting or layout details.

Fully compatible with Microsoft Office formats like .docx, .xlsx, and .pptxLightweight installation that consumes minimal system resourcesAll-in-one suite including Writer, Spreadsheet, Presentation, and a built-in PDF editorFamiliar UI requiring zero learning curve for transitioning Office users

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access query show records but my form does not?

This commonly happens if the form's 'Data Entry' property is set to 'Yes', which forces the form to only accept new entries while hiding historical data. It can also occur if a form filter is currently active.

What are Link Master and Link Child fields in Access?

These properties define the relational link between a main form and its subform. They ensure that the subform only displays the specific records related to the current active record in the main form.

How do I completely remove a persistent filter in Access?

You can clear a filter by clicking 'Toggle Filter' on the Home tab ribbon, clicking the 'Filtered' indicator on the bottom navigation bar, or changing the 'Filter On Load' property to 'No' in the form's Design View.

Will changing the Data Entry property delete my data?

No. Changing the 'Data Entry' property from 'Yes' to 'No' only changes how the form displays data; it does not delete or alter the actual records safely stored in your database tables.

Office Quick Solutions