Make Multi-Table Forms Editable in Access 2016
Question details
Make an Access 2016 form based on four related tables editable so users can add, change, and delete records.

- Product
- Microsoft Access 2016
- Device & OS
- not provided
- Scenario
- A form displays fields from four related tables using a multi-table query as its record source.
- Observed behavior
- The form displays records but does not allow users to edit, delete, or add data.
Identify the primary and foreign keys that link the four tables. In Access, open Database Tools > Relationships to review how the tables are connected.
Use a Main Form With Linked Subforms
Use separate forms for related tables when a single multi-table query prevents data entry.
A main form can display the parent record while linked subforms manage related records. Each form should use an updateable table or query as its record source.
In the Navigation Pane, select the parent table and choose Create > Form. Save the form with a descriptive name.
Select a related child table in the Navigation Pane and choose Create > Form. Save it, then repeat for other related tables that need their own forms.
Open the main form in Design View and use the Subform/Subreport control on the Design tab to add each saved subform. Use the wizard to select the matching parent key and child foreign key, or select the subform control and set Link Master Fields and Link Child Fields in its Property Sheet.
Open the main form in Form View. Select a parent record, then try adding and editing a related record in each subform. Test deletion only where the relationships and permissions allow it.

Check Form Editing Properties and Record Sources
Use these checks if a main form or subform is still read-only after you restructure it.
Use WPS Office for Documents, Spreadsheets, and Presentations
WPS Office is a free, lightweight alternative for working with familiar Office-style tools and moving compatible files between suites. Access is still required to create or edit Access database forms.

Frequently Asked Questions
Why can I see records but not edit them in an Access form?
The form's multi-table query may not be updateable. Open the query directly from the Navigation Pane to test it, and consider using a main form with linked subforms for the related tables.
How do I link a subform to the current main-form record?
Open the main form in Design View, select the subform control, and open its Property Sheet. Set Link Master Fields to the parent key and Link Child Fields to the matching child foreign key.
Why can't I delete a parent record?
Referential integrity may prevent deletion when related child records exist. Review the relationships under Database Tools > Relationships and check the applicable deletion rules before removing records.
Can WPS Office edit my Access forms?
WPS Office does not replace Access for creating or editing Access database forms. It can be used for compatible documents, spreadsheets, and presentations instead.




