The Filter event occurs when you design a filter to limit the form's records to those matching specified criteria. This event takes place when you select the Filter By Form or Advanced Filter/Sort options. Use this event to remove the filter that was previously set, to enter initial settings for the filter, or to call your own custom filter dialog box. To cancel the filtering command, set the Cancel argument for the event procedure to True.

The event procedure in Hands-On 24-18 allows the user to use the Filter by Form option but disallows the use of the Advanced Filter/Sort option.

0 0

Post a comment