How to Fix the Access Subform Join Key Not in Recordset Error
Question details
The user needs to resolve an error preventing them from adding new records in a Microsoft Access subform.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Attempting to enter new data into an editable subform (like course registrations) that is linked to a parent main form (like employee details).
- Observed behavior
- Access triggers a 'Join Key Not in Recordset' error because it cannot identify where new records should be stored or fails to automatically inherit the foreign key from the parent form.
Verify that you have Design View permissions for your Access database and ensure that primary and foreign keys are properly defined in your database tables.
Correctly Bind and Link Form Fields
Fix the error by ensuring the main form and subform are bound to the correct tables and their master/child link fields are explicitly set.
When an Access subform is not correctly bound to the underlying table or lacks the necessary foreign key in its recordset, the database cannot inherit the parent ID for new records. Adjusting the Link Master and Link Child properties will resolve this.
In the Access Navigation Pane, right-click your main form and select 'Design View'.
Ensure the main form's Record Source is set to the primary table (e.g., Employees) and the subform's Record Source is set directly to the secondary table (e.g., Course Registrations) or an updatable query.
Click the outer edge of the subform control to select it. Open the Property Sheet (F4), navigate to the 'Data' tab, and set both 'Link Master Fields' and 'Link Child Fields' to the shared identifier, such as EmployeeID.
Confirm that the subform's underlying table or query includes the foreign key field (EmployeeID). If using a query, drag the foreign key field into the query grid.

Looking for a Better Office Suite? Try WPS Office
While WPS Office does not include a database application like Microsoft Access, it is an incredibly lightweight and powerful alternative for all your Word, Excel, and PowerPoint needs. Enjoy premium document editing without the heavy subscription fees.

Frequently Asked Questions
Why does Microsoft Access display 'Join key not in recordset'?
This occurs when the fields linking your main form to the subform are missing from the subform's underlying recordset. Access needs these fields present in the query or table to automatically assign the parent ID to new subform entries.
Can I use a multi-table query for my data-entry subform?
Yes, but only if the query remains updatable. If the relationships between joined tables prevent new records from being safely added, Access will lock the recordset and display errors. Sticking to a single base table for a subform is generally safer for data entry.
How do I check if my Access query is updatable?
Open the query in Datasheet View. If the 'New Record' row at the bottom (marked with an asterisk) is grayed out or you cannot type into the fields, the query is read-only and cannot be used for an editable subform.




