Others

Fix Access Form Showing Only a Blank New Record

Adam Davis Oct 23, 2026 868 views

Question details

The user needs to resolve an issue where a Microsoft Access form only displays a blank new record instead of showing existing database records.

How to Fix an Access Form Showing Only a Blank New Record

Product: Microsoft Access
Device & OS: not provided
Scenario: Opening an existing form to view or edit previously entered database records.
Observed behavior: The form displays only a blank row for a new record, hiding all existing data.

Before you start

Ensure you have the necessary design permissions to modify form properties and underlying queries within the Access database.

Solution 1Recommended

Change the Data Entry Property to No

Adjusting the Data Entry property is the primary fix when a form hides existing records and only allows new entries.

The Data Entry property is often misunderstood. When set to 'Yes', Access assumes the form is strictly for adding new records and hides historical data. Switching it to 'No' allows the form to both display existing records and accept new ones.

Open Design View

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

Access the Property Sheet

Click the 'Property Sheet' button located on the Form Design ribbon tab. Alternatively, press F4.

Navigate to the Data Tab

Ensure the selection type dropdown at the top of the Property Sheet is set to 'Form', then click the 'Data' tab.

Modify the Data Entry Property

Locate the 'Data Entry' property in the list. Click its dropdown arrow and change the value from 'Yes' to 'No'.

Save and Verify

Save the form changes and switch to 'Form View' to confirm that existing records are now visible.

Property Adjusted: Your form should now display previous records and still allow the addition of new ones at the end of the recordset.

Solution 2

Verify Query Updateability

If changing the Data Entry property doesn't resolve the editing issue, the underlying query acting as the record source might be read-only.

Free Microsoft Office alternative

Looking for a Free Office Suite? Try WPS Office

While Microsoft Access handles databases, you likely also need reliable tools for documents, spreadsheets, and presentations. WPS Office is a highly compatible, free, and lightweight alternative to Microsoft Office that covers your daily productivity needs without the hefty price tag.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Lightweight design that runs smoothly on almost any computer.Familiar and intuitive user interface for seamless migration.Built-in robust PDF editing and conversion tools.

Frequently Asked Questions

Why does my Access form only show a blank record when I open it?

This typically happens if the 'Data Entry' property in the form's property sheet is set to 'Yes'. This setting explicitly restricts the form to only accepting new records, effectively hiding all existing data upon opening.

Can an inner join cause an Access form to be uneditable?

Yes, certain complex queries—especially those with many-to-many relationships, missing primary keys, or improper inner joins—can make the resulting recordset read-only. If the underlying query cannot be updated, the form bound to it won't allow edits.

How do I make my Access query updateable again?

To fix a read-only query, ensure that it includes primary key fields from all joined tables, verify that you have update permissions on the underlying tables, and avoid using aggregate functions like SUM or GROUP BY, which inherently lock data editing.

Office Quick Solutions