Others

Fix Microsoft Access Form Records Disappearing After Entry

Maira Mehtab Sep 20, 2026 869 views

Question details

The user needs to understand why records entered into an Active Event List form are disappearing from view upon continuing, even though the data is saved and visible in the Event Report.

Product: Microsoft Access
Device & OS: not provided
Scenario: Entering event records into a database form in a school laboratory setting.
Observed behavior: Newly entered events vanish from the Active Event List form view when the user continues, although the records are successfully saved and remain visible in the Event Report.

Before you start

Ensure you have the affected Microsoft Access database open in Design View and that you have sufficient administrative permissions to modify form properties.

Solution 1Recommended

Change the Form DataEntry Property to False

The most common reason for records disappearing after entry is that the form's Data Entry property is set to True, which restricts the form to only display a blank screen for adding new data.

When an Access form has its DataEntry property set to 'Yes' (True), it ignores existing records in the underlying table and only allows you to input new records. By changing this to 'No' (False), the form will display previously inserted records while still allowing new ones to be added.

Open Design View

In the Access Navigation Pane on the left, right-click your 'Active Event List' form and select 'Design View'.

Open the Property Sheet

Press the 'F4' key on your keyboard to open the Property Sheet pane on the right side of the screen.

Modify the Data Entry Setting

Click on the 'Data' tab within the Property Sheet. Find the property labeled 'Data Entry' and click the dropdown arrow to change its value from 'Yes' to 'No'.

Save and Test

Save your form by clicking the Save icon or pressing Ctrl+S. Switch back to 'Form View' to verify that your past events are now visible.

Check Data Source: Changing this setting ensures the form loads all underlying data from its table or query instead of just a blank entry row.

Solution 2

Verify Default View and Record Source Settings

If the Data Entry property is already set correctly, the form might be restricted by its Default View or an underlying query filter.

Free Microsoft Office alternative

Use WPS Office for Easier Data List Management

While Microsoft Access is powerful for complex relational databases, managing simple lists like a laboratory event log can be much easier in WPS Spreadsheet. WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office, allowing you to easily track data, create forms, and generate reports without struggling with complex database properties.

1. Create a New List: Open WPS Spreadsheet and create a new blank workbook to act as your event log.
2. Set Up Headers: Enter your column headers (e.g., Date, Event Name, Details) in the first row and format it as a table.
3. Use Data Forms: Click 'Form' on the Quick Access toolbar or Data tab to easily enter new records in a popup window. All entries will automatically stack in your visible spreadsheet list.

Fully compatible with Microsoft Excel (.xlsx) formats for easy data list management and sharing.Free, lightweight, and fast installation compared to traditional heavy database software.Built-in Data Form tools to streamline event entry without worrying about disappearing records.Familiar tabbed interface that requires zero learning curve for new users.

microsoft office alternative - wps office

Frequently Asked Questions

What does the Data Entry property do in an Access form?

The Data Entry property determines whether a form opens exclusively for adding new records. When set to 'Yes', it hides all existing records and only presents a blank form for new entries.

Why do my Access records show in reports but not in the form?

Reports typically pull all data directly from the underlying table or query, regardless of how a form is configured. If a form is set to Data Entry mode, it intentionally hides existing data for faster input, causing this visual discrepancy.

How do I switch between Design View and Form View in Access?

You can switch views by right-clicking the form's document tab and selecting the desired view from the context menu, or by clicking the View button located on the Home tab of the ribbon.

Can I use continuous forms to show all past laboratory events?

Yes, by changing the form's Default View property to 'Continuous Forms' (and ensuring Data Entry is set to No), you can scroll through all past and current event records vertically on a single screen.

Office Quick Solutions