Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Form.AllowFilters Property (Access)

You can use the AllowFilters property to specify whether records in a form can be filtered. Read/write Boolean.

expression .AllowFilters

expression A variable that represents a Form object.

Filters are commonly used to view a temporary subset of the records in a database. When you use a filter, you apply criteria to display only records that meet specific conditions. In an Employees form, for example, you can use a filter to display only records of employees with over 5 years of service. You can also use a filter to restrict access to records containing sensitive information, such as financial or medical data.

Note Note

Setting the AllowFilters property to No does not affect the Filter , FilterOn , ServerFilter , or ServerFilterByForm properties. You can still use these properties to set and remove filters. You can also still use the following actions or methods to apply and remove filters.

Actions

Methods

ApplyFilter

ApplyFilter

OpenForm

OpenForm

ShowAllRecords

ShowAllRecords

Show:
© 2015 Microsoft