Access 2003
I have a form (bound to a query) and would like for the user to check
a CheckBox to filter records based on a value of one of the fields.
If the CheckBox is not checked, it should show all the records. Here
is the query criteria I am using:
IIf([forms]![frmViolations]![Check156]=True,[forms]![frmViolations]!
[txtStation],"*")
The action this line is performing:
If the checkbox on the form is checked (i.e., True), the query uses
the value of the control txtStation (That works), but if it is
unchecked, the "*" doesn't work. It returns nothing. "??" doesn't
work either.
The alternative is to use a seperate recordsource altoghether, which I
am trying to avoid. Any suggesting greatly appreciated!!!
RBolling
I have a form (bound to a query) and would like for the user to check
a CheckBox to filter records based on a value of one of the fields.
If the CheckBox is not checked, it should show all the records. Here
is the query criteria I am using:
IIf([forms]![frmViolations]![Check156]=True,[forms]![frmViolations]!
[txtStation],"*")
The action this line is performing:
If the checkbox on the form is checked (i.e., True), the query uses
the value of the control txtStation (That works), but if it is
unchecked, the "*" doesn't work. It returns nothing. "??" doesn't
work either.
The alternative is to use a seperate recordsource altoghether, which I
am trying to avoid. Any suggesting greatly appreciated!!!
RBolling
Comment