ACC: Setting Filter Property of Form Does Not Apply Filter (148299)

RESOLUTION

You need to set the FilterOn property of the form to True to activate the filter. If you want the filter to be applied when the form opens, you can set the FilterOn property to True on the Open event of the Form. You can do this using either a SetValue action in a macro or through Visual Basic code, as demonstrated below.

Using a Macro in the Open Event Procedure of the Form

To apply a filter when the form is opened, create the following macro and set the form's OnOpen property event procedure to this macro:

   Action
   --------
   SetValue


   SetValue Action
   ----------------
   Item: FilterOn
   Expression: True
				

Using Visual Basic Code in the Open Event Procedure of the Form

To apply a filter when the form is opened, set the form's OnOpen property to the following event procedure:

   Private Sub Form_Open(Cancel As Integer)
      Me.FilterOn = True
   End Sub
				

The filter may also be applied, while the form is open, by simply clicking the Apply Filter button on the built-in toolbar or by clicking the Apply Filter/Sort option on the Records menu.