Others

How to Hide Completed Access Records Without Deleting Them

Maira Mehtab Sep 27, 2026 868 views

Question details

The user wants to hide records marked as completed from a form or subform in Microsoft Access without permanently deleting the underlying data from the table.

Product: Microsoft Access
Device & OS: not provided
Scenario: Managing data visibility in Access forms based on completion status to keep the workspace clean.
Observed behavior: Completed records currently remain visible in the active form view, cluttering the interface for ongoing tasks. The goal is to filter these out while safely retaining historical data.

Before you start

Identify the exact name of your database table and the specific date field (e.g., CompletionDate) used to track whether a record is finished before modifying your form's record source.

Solution 1Recommended

Filter Subforms Using a NULL Date Query

Change the record source of your form or subform to an SQL query that excludes records where the completion date is filled out.

By binding your form to a specific SQL query rather than directly to the table, you can dynamically control which records are displayed. When a completion date is entered, the record automatically disappears from the active view but remains safely stored in the backend table.

Open Design View

Open your Microsoft Access database, right-click the form or subform you want to modify, and select 'Design View'.

Access the Property Sheet

Press F4 to open the Property Sheet pane and navigate to the 'Data' tab.

Modify the Record Source

In the 'Record Source' property, enter an SQL query to filter out completed items, such as: SELECT * FROM YourTable WHERE SomeDateField IS NULL;

Customize the Query

Replace 'YourTable' with your actual table name and 'SomeDateField' with the name of your completion date field.

Save and Verify

Save the form changes and switch back to 'Form View' to verify that completed records are now hidden.

Data Retention: This method only affects form visibility. The entire row of data remains securely in the original table and will not disappear entirely.

Solution 2

Create a Separate Management Form for Hidden Records

Build a dedicated form to search, view, and correct records that have already been marked as completed and hidden from the main view.

Free Microsoft Office alternative

Looking for a Lightweight Data Management Alternative?

While Microsoft Access is a robust database tool, many data tracking and record management tasks can be handled more simply using spreadsheets. WPS Office provides a powerful, free alternative featuring advanced spreadsheet capabilities fully compatible with Excel.

1. Download WPS Office: Download and install WPS Office Free from the official website.
2. Open WPS Spreadsheet: Create a new spreadsheet document to log and track your records.
3. Filter Your Data: Use the 'Data' tab to apply Filters, instantly hiding rows that are marked as 'Completed' without deleting them.

Free, lightweight, and fast-loading office suiteFully compatible with Microsoft Excel (.xlsx), Word, and PowerPoint formatsEasily manage records, apply data filters, and hide completed tasks using built-in spreadsheet functionsFamiliar user interface with no steep learning curve

Frequently Asked Questions

Will hiding the record in the form delete the underlying data?

No, modifying the form's Record Source to exclude completed items only changes what is displayed on the screen. The original data remains completely intact and safely stored in your Access table.

How can I edit a record after it has been hidden?

You can either manually edit the values directly by opening the Access table, or build a separate management form that does not have the date filter applied, allowing you to search and update completed records.

Can I filter out records based on a checkbox instead of a date?

Yes. If you use a Yes/No field (checkbox) for completion instead of a date, you can change your SQL query to: SELECT * FROM YourTable WHERE IsCompleted = False;.

Office Quick Solutions