Microsoft KB Archive/148299

= ACC: Setting Filter Property of Form Does Not Apply Filter =

Article ID: 148299

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q148299



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



SYMPTOMS
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

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.



STATUS
This behavior is by design.



Steps to Reproduce Behavior

 * 1) Open the sample database Northwind.mdb.
 * 2) Open the Orders form.
 * 3) Press CTRL+G to open the Debug window. In the Debug window, type the following line, and then press ENTER:

Forms!Orders.Filter = "OrderID = 10002"

Note that nothing is returned.
 * 1) In the Debug Window, type the following line, and then press ENTER:

Forms!Orders.FilterOn = True

Note that the filter is applied.

Keywords: kbprb KB148299

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.