A
aWs
I've developed an application using Access 9.0.2720 and most of my users are
using Access 9.0.6926(SP-3). I have a form that allows users to choose what
to filter for, then press the filter button.
On my machine, I change an option, press filter button, the filter is
applied. I can then change the option, press filter, and the new item is
applied.
On my users machines, the first selection is applies, no others are applied.
Here is my code to try to fix it:
If IsLoaded(stDocName) Then
DoCmd.SelectObject acForm, stDocName
Forms![frmContract].DataEntry = False
Forms![frmContract].Filter = ""
Forms![frmContract].FilterOn = False
DoCmd.ApplyFilter "qryContractPopUpFilter"
Forms![frmContract].FilterOn = True
using Access 9.0.6926(SP-3). I have a form that allows users to choose what
to filter for, then press the filter button.
On my machine, I change an option, press filter button, the filter is
applied. I can then change the option, press filter, and the new item is
applied.
On my users machines, the first selection is applies, no others are applied.
Here is my code to try to fix it:
If IsLoaded(stDocName) Then
DoCmd.SelectObject acForm, stDocName
Forms![frmContract].DataEntry = False
Forms![frmContract].Filter = ""
Forms![frmContract].FilterOn = False
DoCmd.ApplyFilter "qryContractPopUpFilter"
Forms![frmContract].FilterOn = True