Apply Filter To View Select Records In. Select the column that you want to filter by cell color and click Data Filter see screenshot. Using this approach you filter the records in a form or report by setting the filtername argument of the OpenForm or OpenReport method or action to the name of the filter query you create.
On the record selector bar verify that either the Unfiltered or the. The Filter function finds records in a table that satisfy a formula. Click on the Apply drop-down and choose your desired option.
SELECT CompanyName ContactName FROM Customers WHERE State.
Adds filters on the primary key fields that point to the current record of the page. Datasheet Form Report or Layout. You can select multiple values from the list but in an app the filter list closes each time you select an option. To apply a rolodex filter to a list.
