Query Criteria based on combo box on a form 1

[sjdk]

Ok, I have searched and searched and I just can not find the answer I am looking for....

I have a form with a combo box to choose if I want salary codes to print on my report. (Yes, No) In my query criteria I was trying to do is this:

like IIf(forms!frmOptions!cboSalaries = "yes", "*", ">0199")

When I run the report from the form, the true part of the expression works just fine, but the false part doesn't work. I know that the query is going to look for a value of ">0199" rather than looking for values greater than 0199. I have a feeling that this is something stupid that I am just missing, but I am just not seeing it.

Thanks in advance....
Steph

 

[PHV]

> '0199' OR [Forms]![frmOptions]![cboSalaries] = 'yes'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sjdk]

Hmmm....not quite what I need...

If I choose "Yes" on the form, I want all codes to print, if I choose "No" on the form, I only want codes >0199 to print.

Thanks!

 

[PHV]

I thought the criteria I gave you was exactly that ...

 

[sjdk]

Oh my gosh, am I ever thick today....a million pardons...you have provided me with EXACTLY what I was looking for....I was just trying to make it harder than it was. I can't thank you enough!!!

THANKS!!
Steph