ACC: Setting Filter Property of Form Does Not Apply Filter

• Microsoft Access versions 7.0, 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

Setting the Filter property of a form doesn't apply a filter.

CAUSE

The Filter property holds the filter that will be applied when a filter is activated, but does not activate filtering.

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

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior