AllowFilters Property [Access 2003 VBA Language Reference]
You can use the AllowFilters property to specify whether records in a form can be filtered. Read/write Boolean.
expression Required. An expression that returns one of the objects in the Applies To list.
The AllowFilters property uses the following settings.
|Yes||True||(Default) Records can be filtered.|
|No||False||Records can't be filtered.|
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 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.
Applies to | Form Object