Others

Fix Microsoft Access Form Records Not Saving with Related Subforms

Tauseeq MagsiTauseeq Magsi Nov 20, 2026 868 views

Question details

Determine why records entered through a Microsoft Access form are not stored or displayed as expected.

Fix Microsoft Access Form Records Not Saving with Related Subforms
Product
Microsoft Access
Device & OS
not provided
Scenario
Entering related records through a form based on a query that joins multiple tables.
Observed behavior
Table updates appear incorrect, or entered records are missing when the form is reopened.
Before you start

Identify the parent and child tables and the fields that connect them. Open each table in Datasheet View to check whether the records were actually stored.

Solution 1Recommended

Link related tables through a main form and subforms

Use this approach when one form is based on a query joining multiple tables and related records are not saving or appearing as expected.

A main form can manage the parent record while each subform manages records in a related child table. The linked key fields associate the child records with the current parent record.

1
Check the relationship

Open Database Tools > Relationships and verify that the parent table's primary key is related to the corresponding foreign key in the child table.

2
Create the main form

Select the parent table in the Navigation Pane, then use Create > Form to create a form bound to that table.

3
Add a subform

Open the main form in Design View and use the Subform/Subreport control to add a subform based on the related child table or an existing child form.

4
Verify the link fields

Select the subform control in Design View, open its Property Sheet, and check that Link Master Fields names the parent key and Link Child Fields names the matching foreign key.

5
Test the records

Open the main form in Form View, enter and save a parent record, then enter a related record in the subform. Reopen the form and inspect both tables in Datasheet View to confirm that the records and matching keys are stored.

Link related tables through a main form and subforms
If a record is still missing: If the record exists in the table but not on the form, check the form's Record Source and any active filters. If it is absent from the table, check for validation errors and whether the form allows additions.
Free Microsoft Office alternative

Use WPS Office for documents and spreadsheets alongside Access

WPS Office is a free, lightweight Office alternative with a familiar interface for working with documents and spreadsheets. Compatible formats make it easier to move everyday files between Office suites; WPS Office does not repair Access forms or replace an Access database.

Review related tabular data in WPS Spreadsheets after exporting it from Access.Open and edit common Microsoft Office formats, including XLSX, DOCX, and PPTX.Use familiar document and spreadsheet tools in a lightweight suite.Move everyday document and spreadsheet files between WPS Office and Microsoft Office.
microsoft office alternative - wps office

Frequently Asked Questions

Why does a record disappear when I reopen my Access form?

Open the underlying table in Datasheet View to see whether the record was stored. If it is there, check the form's Record Source and filters; if it is not, look for validation errors or problems with the form's data source.

Where do I set the fields that link a subform to its main form?

Open the main form in Design View, select the subform control, and open the Property Sheet. Set Link Master Fields to the parent key and Link Child Fields to the corresponding foreign key.

Do I need to save the parent record before adding a child record?

Save the parent record first so its primary key is available for the related child record. Then enter the child record in the linked subform.

Can a query that joins multiple tables prevent form updates?

Some multi-table queries are not updateable or do not update records as expected. Check the query's updateability and consider using a parent form with linked subforms for the related tables.