Others

How to Fix an Access Subform That Will Not Accept Data

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to resolve an issue where a Microsoft Access subform has stopped accepting new records.

Product: Microsoft Access
Device & OS: not provided
Scenario: Attempting to enter new data into an Access subform linked to a parent form.
Observed behavior: The subform fails to accept new data, which is usually caused by incorrect parent-child link field settings or a recent form design change.

Before you start

Switch your Microsoft Access database to Design View and ensure that the underlying tables or queries for both the main form and subform are not set to read-only.

Solution 1Recommended

Verify Subform Link Properties

Check the LinkMasterFields and LinkChildFields properties to ensure the subform is correctly mapped to the parent form.

A subform relies on primary and foreign keys to synchronize with the parent form. If these properties are unassigned or incorrect, the subform will not accept new data.

Test the Subform

Double-click the subform in the Navigation Pane to run it independently. Check if it accepts data on its own to isolate the issue to the parent-child relationship.

Open Design View

Open the main form containing the subform in Design View.

Access the Property Sheet

Click once on the edge of the subform control to select it, then press F4 to open the Property Sheet.

Check Link Fields

Navigate to the Data tab in the Property Sheet. Verify that LinkMasterFields references the parent's primary key and LinkChildFields references the child's foreign key.

Independent Testing Passed: If you can enter data into the subform when running it independently, correcting the LinkMasterFields and LinkChildFields will immediately resolve the relationship issue.

Solution 2

Restore a Working Version of the Form

Revert to a previously functioning version of your form if recent design changes disrupted the data entry process.

Free Microsoft Office alternative

Looking for a Lightweight Alternative to Microsoft Office?

While WPS Office does not include a database management program like Access, it provides a highly compatible, free, and comprehensive suite for your document, spreadsheet, and presentation needs. Enjoy a familiar interface and seamless workflow transition.

1. Visit WPS Official Site: Go to the official WPS Office website to download the installer for your operating system.
2. Install the Suite: Run the setup file and follow the on-screen instructions to complete the fast installation.
3. Open Your Files: Launch WPS Office and instantly open your existing Office documents without formatting loss.

Highly compatible with Microsoft Word, Excel, and PowerPoint formats.Lightweight design that runs smoothly on PC, Mac, and mobile devices.Familiar user interface with a zero learning curve.Advanced PDF viewing and editing tools included for free.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access subform say the recordset is not updatable?

This happens if the underlying query of the subform lacks primary keys, contains ambiguous joins, or lacks update permissions. Check the query design and ensure it allows direct edits.

What if the subform does not accept data even when run independently?

If data entry fails independently, check the subform's Data properties. Ensure 'Allow Additions' and 'Allow Edits' are set to Yes, and verify that the underlying table is not locked or read-only.

Can I link a subform without using the LinkMasterFields property?

While it is technically possible using VBA code to filter recordsets dynamically, using LinkMasterFields and LinkChildFields is the most reliable, standard method for maintaining a parent-child synchronization in Access.

Office Quick Solutions