Save Microsoft Access Subform Default Values to a Related Table
Question details
The user needs default values displayed in Access subforms to be saved to related tables when the main form is saved.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A main form and its subforms are linked by an ID, and the user wants a related record containing a default value.
- Observed behavior
- The displayed default is not added to the related table when the main form is saved; the value is saved after the subform is manually edited.
Open the main form in Design View and identify the parent ID field, the subform control, and the related table's foreign key. Check that the subform control displaying the default is bound to the intended table field.
Check the subform link and save a child record
Use this method when you can create the related record by editing the subform.
A displayed default value does not necessarily create a child record. Saving the main form saves the parent record, but a new subform record must also be created and saved. A single-record subform is not necessarily the cause.
In the main form's Design View, select the subform control and open its Property Sheet. On the Data tab, verify that Link Master Fields names the parent ID and Link Child Fields names the matching foreign key in the subform's record source.
Open the subform in Design View, select the control showing the default, and check Control Source and Default Value on its Property Sheet. The Control Source should name the field that stores the value.
Open the main form in Form View, enter the parent data, and press Shift+Enter to save the record and generate its ID.
Click the new-record row in the subform, enter or change a bound field, and complete any other required fields. Press Shift+Enter while the cursor is in the subform, then check the related table for the new record.

Append a related record after saving the main form
Use an append query when a child record must be created even if the user does not edit the subform.
Use WPS Office for Everyday Office Documents
WPS Office is a free, lightweight alternative for working with documents, spreadsheets, and presentations. Its familiar interface and Microsoft Office format compatibility make it easy to move everyday files across, although it does not fix Access subforms or replace an Access database.

Frequently Asked Questions
Why does the default appear in the subform but not in the table?
The default can be displayed on a new-record row without creating a child record. Edit a bound field in the subform and save the record, or use an append query after saving the parent.
Where do I find Link Master Fields and Link Child Fields?
Open the main form in Design View, select the subform control, and open the Property Sheet. Find both properties on the Data tab.
Will changing the Default Value property update existing records?
No. A default is intended for new records. To update existing blank values, use an appropriate update query or edit those records directly.
Can I create the related record without editing the subform?
Yes. After the main record is saved and has an ID, run an append query that inserts the ID, default value, and any other required fields into the related table. Check for an existing child record if duplicates are not allowed.




