To run a macro when the ApplyFilter event occurs, set the OnApplyFilter property to the name of the macro.
You can check a filter, or even change the criteria the user has entered, by reading the value of the Filter property in a macro condition, or setting the value of the property using the SetValue action in an ApplyFilter macro.
You can use the CancelEvent action in an ApplyFilter macro to cancel applying the filter. You can use a condition to check the value of one or more controls on the form, and apply a filter only when appropriate. For example, if a HasOutstandingOrders check box is selected in an Orders form, you could apply a filter to show these outstanding orders in the records on the form. Otherwise, you can cancel applying the filter, and display a message saying there are no outstanding orders to display.
ApplyFilter Event — Event Procedures.