# How to Filter Data in MS Access Form

> To filter data in an MS Access form, open the form in Form View, select Advanced under the Home tab on the ribbon, and choose Filter By Form. Next, enter your criteria in the blank form fields that appear and press Toggle Filter to apply the changes.

Canonical: https://livedemo.ai/tutorials/how-to-filter-data-in-ms-access-form/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3df5ab56e05a00fe5af5/preview?step=1

## Steps

1. Open the form in 'Form View'.
2. On the ribbon under the 'Home' tab, click 'Advanced'.
3. From the drop-down menu, select 'Filter By Form'.
4. A blank version of the form appears.
5. Enter criteria in the fields.
6. Press 'Toggle Filter' to apply the filter.