Office Settings & Configuration

Make Multi-Table Forms Editable in Access 2016

Nimra MalikNimra Malik Nov 14, 2026 868 views

Question details

Make an Access 2016 form based on four related tables editable so users can add, change, and delete records.

Make Multi-Table Forms Editable in Access 2016
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.
Before you start

Identify the primary and foreign keys that link the four tables. In Access, open Database Tools > Relationships to review how the tables are connected.

Solution 1Recommended

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.

1
Create the main form

In the Navigation Pane, select the parent table and choose Create > Form. Save the form with a descriptive name.

2
Create related subforms

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.

3
Add and link the subforms

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.

4
Test data entry

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.

Use a Main Form With Linked Subforms
Check the relationship structure: A table related to another child table may need a nested subform rather than a direct link to the main form. Referential integrity rules can also prevent deletion of records that have related records.
Free Microsoft Office alternative

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.

Use spreadsheets to organize related lists of data outside an Access formOpen and edit compatible Microsoft Word, Excel, and PowerPoint formats, including DOCX, XLSX, and PPTXWork in a familiar interface that makes migration easierUse a free, lightweight office suite for everyday files
microsoft office alternative - wps office

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.