Apply Filter

The ApplyFilter event occurs when you apply the filter to restrict the records. This event takes place when you select the Apply Filter/Sort, Filter by Selection, or Remove Filter/Sort options. Use this event to change the form display before the filter is applied or undo any changes made when the Filter event occurred.

The ApplyType argument can be one of the predefined constants shown in

Table 24-1.

Table 24-1: ApplyType argument constants

Table 24-1.

Table 24-1: ApplyType argument constants

Constant Name

Constant Value

acShowAllRecords

0

acApplyFilter

1

acCloseFilterWindow

2

acApplyServerFilter

3

acCloseServerFilterWindow

4

The event procedure in Hands-On 24-19 displays a different message depending on whether or not the user has made a selection in the Filter by Form window.

0 0

Post a comment