Others

How to View and Edit Existing Table Records in a Microsoft Access Form

Elise Williams Oct 21, 2026 868 views

Question details

The user needs to display and edit existing table records in a Microsoft Access form, but the form might only be allowing new data entry.

How to View and Edit Existing Table Records in a Microsoft Access Form

Product: Microsoft Access
Device & OS: not provided
Scenario: Using a form connected to a table or query to manage database records.
Observed behavior: Existing records do not appear in the form, and only blank fields for entering new data are visible.

Before you start

Ensure your Microsoft Access database is not opened in 'Read-Only' mode, and verify that the table or query connected to your form actually contains saved data.

Solution 1Recommended

Change the Data Entry Property to 'No'

Modify the form's properties to allow displaying and editing of existing records instead of only accepting new entries.

By default, if a form is set to Data Entry mode, it is intended only for inputting new records. Changing this property to 'No' creates a normal form that displays existing records while still allowing new records to be added.

Open Design View

Locate the problematic form in the Microsoft Access Navigation Pane, right-click it, and select 'Design View'.

Open the Property Sheet

Press F4 on your keyboard, or click the 'Property Sheet' button on the Design tab of the ribbon to open the properties pane.

Select the Form Object

Ensure that 'Form' is selected in the drop-down list at the very top of the Property Sheet.

Modify Data Properties

Navigate to the 'Data' tab within the Property Sheet. Find the 'Data Entry' property and change its value from 'Yes' to 'No'.

Save and Test

Save your changes and switch to 'Form View'. You should now be able to navigate through and edit your existing table records.

Form Behavior Restored: The form will now function as a standard data management interface, allowing you to browse, edit, and add new records.

Solution 2

Verify the Form's Record Source

Ensure the form is connected to the correct, updatable table or query.

Free Microsoft Office alternative

Looking for a Free Alternative to Microsoft Office?

While Microsoft Access is a specialized relational database tool, most daily data organization, tracking, and calculation tasks can be handled seamlessly using WPS Spreadsheet. WPS Office provides a fully compatible, lightweight, and free alternative to Microsoft Word, Excel, and PowerPoint.

1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
2. Install the Suite: Run the installer and follow the on-screen instructions to set up WPS Office on your computer.
3. Open and Edit Data: Launch WPS Spreadsheet to open your existing Excel data files and manage them with ease.

Highly compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Organize and filter tabular data efficiently without complex database configurations.Lightweight design ensures smooth performance even on older devices.Familiar user interface makes switching easy with zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my Microsoft Access form opening blank even though there is data in the table?

This usually happens when the form's 'Data Entry' property is set to 'Yes'. This setting restricts the form to only accept new records, hiding all previous data. Changing the property to 'No' will reveal existing records.

What is the difference between Data Entry mode and normal mode in Access?

Data Entry mode forces the form to open on a blank new record and hides existing entries. Normal mode (Data Entry = No) displays all existing records and allows you to navigate through them, edit them, or add new ones at the end of the recordset.

Can I use an Access query as a Record Source to edit existing data?

Yes, as long as the query is updatable. Some complex queries, such as those with aggregate functions, Totals, or certain joins, create read-only recordsets that cannot be edited through a form.

How do I quickly switch between Form View and Design View?

You can right-click the form's document tab at the top of the workspace and select your desired view, or use the View button located on the Home tab of the ribbon interface.

Office Quick Solutions