Others

How to Hide Records in a Microsoft Access Form Using Criteria

Muhammad Talha Oct 22, 2026 868 views

Question details

The user wants to hide certain records in a Microsoft Access form based on specific criteria while browsing.

How to Hide Records in a Microsoft Access Form Using Criteria

Product: Microsoft Access
Device & OS: not provided
Scenario: Creating or browsing a Microsoft Access form where irrelevant or canceled records need to be automatically excluded from the view.
Observed behavior: All records from the underlying table are currently displayed, but the goal is to filter the view so only records that meet specific conditions are shown.

Before you start

Ensure you have your Microsoft Access database open in Design View and clearly identify the exact field and condition (such as Status not equal to 'Cancelled') that will determine which records should be hidden.

Solution 1Recommended

Use a Query with Criteria as the Record Source

The most effective and maintainable method to hide records is to build a query with the necessary criteria and set it as the form's Record Source.

By modifying the form's Record Source to point to a query instead of a direct table, you can easily filter out records without writing complex VBA code. This method ensures that the form only loads the data that meets your criteria.

Create a New Query

Go to the 'Create' tab on the Access ribbon and click 'Query Design'. Select the table your form is based on and add it to the query workspace.

Add Fields and Apply Criteria

Drag all required fields from the table into the query design grid below. In the 'Criteria' row for the target field (e.g., Status), enter your hiding condition, such as <> 'Cancelled'.

Save the Query

Click the Save icon, give your query a descriptive name (like 'ActiveRecordsQuery'), and close the query design window.

Update the Form's Record Source

Open your form in Design View. Open the Property Sheet (F4), navigate to the 'Data' tab, and change the 'Record Source' property from the original table to your newly created query. Save the form.

Use a Query with Criteria as the Record Source

Parameterized Queries: You can also make this query parameterized by entering [Enter Status:] in the criteria row, which prompts the user for a value dynamically when the form opens.

Solution 2

Use the Form's Filter and FilterOn Properties

You can directly apply a filter to the form using its built-in properties without creating a new query.

Free Microsoft Office alternative

Boost Your Daily Productivity with WPS Office

While Microsoft Access handles complex relational database management, WPS Office is the perfect free, lightweight alternative for your daily document, spreadsheet, and presentation needs. Experience a seamless transition with robust file compatibility.

1. Download the Installer: Visit the official WPS Office website and click the free download button.
2. Install WPS Office: Run the downloaded installer file and follow the simple on-screen instructions to complete the setup.
3. Open and Edit Your Files: Launch WPS Office and easily open your existing Word, Excel, or PowerPoint files to continue your work without missing a beat.

Fully compatible with Microsoft Office formats, including .docx, .xlsx, and .pptx.Lightweight software that installs quickly and runs smoothly on older devices.Familiar, user-friendly tabbed interface for easy multitasking.Rich built-in PDF editing tools for free document conversion.

microsoft office alternative - wps office

Frequently Asked Questions

Can I hide records in a form using a parameterized query?

Yes, you can use a parameterized query by entering brackets like [Enter Status:] in the Criteria row of your query design. This prompts the user to input a specific value when opening the form, allowing you to filter out hidden records dynamically without writing any VBA.

Do I need to use VBA code to filter records on a Microsoft Access form?

No, writing VBA is not mandatory. Using a tailored query as the Record Source or configuring the form's Filter and Filter On Load properties in the Property Sheet are both effective, codeless ways to hide records.

Why are my hidden records still showing up after setting a filter?

If you are using the form's built-in Filter property, make sure that the 'Filter On Load' property is set to 'Yes' in the Property Sheet. If you used the query method, double-check that the form's Record Source has been updated to your new query rather than the original table.

Office Quick Solutions