Others

Fix 'Cannot Go to the Specified Record' Error in Microsoft Access

Tauseeq MagsiTauseeq Magsi Nov 2, 2026 869 views

Question details

The user needs to resolve an error that prevents them from navigating to a new record in a Microsoft Access form.

How to Fix 'Cannot Go to the Specified Record' in Microsoft Access
Product
Microsoft Access
Device & OS
not provided
Scenario
Clicking a 'New Record' button on an Access form to enter new data.
Observed behavior
The system displays the error message 'You cannot go to the specified record' and fails to open a new blank record, even though the form is set to allow edits.
Before you start

Verify that your underlying table or query is fully updatable and that you have the necessary write permissions for the database file.

Solution 1Recommended

Verify Form Data Properties

Ensure the form's properties are correctly configured to allow new record additions.

If a form's settings restrict adding new data or if the recordset type is read-only, Access will block navigation to a new record.

1
Open Design View

Right-click your form in the navigation pane and select 'Design View'.

2
Access the Property Sheet

Press F4 to open the Property Sheet. Ensure 'Form' is selected in the dropdown menu at the very top of the Property Sheet.

3
Check Allow Additions

Navigate to the 'Data' tab. Find the 'Allow Additions' property and ensure it is set to 'Yes'.

4
Check Recordset Type

On the same 'Data' tab, verify that 'Recordset Type' is not set to 'Snapshot', as snapshot recordsets do not support data entry.

Verify Form Data Properties
Tip: If your form is based on a complex query, try opening the query directly to see if you can add a record. If not, the query itself is not updatable.
Free Microsoft Office alternative

Looking for a Lightweight Alternative for Word, Excel, and PowerPoint?

While Microsoft Access handles complex relational databases, WPS Office is an excellent, free alternative for your daily document, spreadsheet, and presentation needs. It's lightweight, highly compatible with Microsoft Office formats, and provides a familiar interface to streamline your workflow.

Highly compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight design that runs smoothly on all major operating systems.Familiar, easy-to-use tabbed interface for a seamless transition.Built-in robust PDF editing and conversion tools.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access form say 'You cannot go to the specified record'?

This typically happens if the form's 'Allow Additions' property is set to No, the underlying record source is read-only, or the form is already positioned on a new, blank record when you try to navigate to another one.

How do I make my Access query updatable?

Ensure your query includes primary keys from the joined tables, doesn't use aggregate functions (like SUM or COUNT), and doesn't have the 'Unique Values' property set to Yes.

What does the Data Entry property do in Access forms?

Setting the 'Data Entry' property to Yes forces the form to open directly to a new, blank record and hides all existing records. If this is enabled, clicking a 'New Record' button may trigger an error since you are already on a new record.