Recent content by arizona
-
A
multiple criteria for query using combo boxes
Jon, I tried that and it seems to work good. Thank you for your time and help! -
A
multiple criteria for query using combo boxes
Jon, It is working with the 4 different combo boxes, I get the right records, but you are right about if any of the fields contain a null value. Then those records are not returned. Any ideas on how to get around that? -
A
multiple criteria for query using combo boxes
This is what I was after and it works IIf(Trim(nz([forms]![frmGeneratorSearch]![combo2].[value],""))="",[kw],[forms]![frmgeneratorsearch]![combo2].[value]) Thanks for all the help... -
A
multiple criteria for query using combo boxes
The way I had it returns all the records that have a value in the manufacture field. The method you suggested returns nothing. I know its close but I can't seem to get it yet. Any other suggestions? Thanks for your response. -
A
multiple criteria for query using combo boxes
I have a form with 4 combo boxes that are the criteria for a query. I had seen where someone had used the nz function to turn a null value into a nil string and pass it back to the query if no value was selected for some of the combo boxes. It was something like this...