Filter works only once on some versions.

A

aWs

I have a form that allows users to choose what to filter for, then press the
filter button.

On the machines using 9.0.2720, when I change an option, press filter
button, the filter is applied and I can change options and apply the filter
countless times and successfully apply the filters.
The machines running 9.0.6926(SP-3), will apply the first filter request,
but no others are applied.

Here is my code I used to try to fix the problem. It come from a MSKB
Artical #269380:

If IsLoaded(stDocName) Then

Forms![frmContract].Filter = ""
Forms![frmContract].FilterOn = False
DoCmd.ApplyFilter "qryContractPopUpFilter"
Forms![frmContract].FilterOn = True
 
Top