When you use filter by form to restrict records that appear, you create the filter and then click the Toggle Filter button to apply the filter.
This button is located in the Sort & Filter group on the Home tab.
The Toggle Filter is used to switch between the filtered and unfiltered views.
