Fix Microsoft Access Form Records Not Saving with Related Subforms
Question details
Determine why records entered through a Microsoft Access form are not stored or displayed as expected.

- 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.
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.
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.
Open Database Tools > Relationships and verify that the parent table's primary key is related to the corresponding foreign key in the child table.
Select the parent table in the Navigation Pane, then use Create > Form to create a form bound to that table.
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.
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.
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.

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.

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.




