Table of contents
Collapse the table of content
Expand the table of content

Report.Filter Event (Access)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Occurs when the user opens a filter window by clicking Advanced Filter/Sort.


expression. Filter( ** Cancel, ** FilterType )

expression A variable that represents a Report object.


NameRequired/OptionalData TypeDescription
CancelRequiredIntegerThe setting determines whether to open the filter window. Setting the Cancel argument to True (?1) prevents the filter window from opening. You can also use the CancelEvent method of the DoCmd object to cancel opening the filter window.
FilterTypeRequiredIntegerThe filter window the user is trying to open. The FilterType argument can be acFilterAdvanced.


To run a macro or event procedure when this event occurs, set the OnFilter property to the name of the macro or to [Event Procedure].

You can use the Filter event to:

  • Remove any previous filter for the report. To do this, set the Filter property or ServerFilter property of the report to a zero-length string (" ") in the Filter macro or event procedure. This is especially useful if you want to make sure extraneous criteria do not appear in the new filter. For example, when you use the Filter By Selection feature, the criteria you use (the selected text in the report) is added to the Filter or ServerFilter property WHERE clause expression, and appears in the Advanced Filter/Sort window. You can remove these old criteria by using the Filter event.

  • Enter default settings for the new filter. To do this, set the Filter property or ServerFilter property to include these criteria. For example, you may want all filters for a Products report to display only current products (products for which the Discontinued control in the Products report is not selected).

  • Use your own custom filter window instead of one of the Microsoft Access filter windows. When the Filter event occurs, you can open your own custom form and use the entries on this report to set the Filter property or ServerFilter property and filter the original report. When the user closes this custom form, set the FilterOn property or ServerFilterByForm property of the original report to True (?1) to apply the filter. Canceling the Filter event prevents the Microsoft Access filter window from opening.

See also


Report Object

© 2018 Microsoft