Multiple query criteria entered by Form problems

[jimbo62]

I have an unbound form which references multiple criteria n a query. The problem is when i do not enter any of the date criteria("between" Style) and enter information in any of the other criteria the query brings back 0 records. I tried to put in an "or" statement to specify the year and all records from that year come back, no specifics. my goal is to allow the user to enter only the criteria they have or need and run the query. Is there a way to ignore the criteria except whrer the user enters information? Any help would be appreciated.

Thanks,

Jim

 

[sha76]

If I've understood the problem right then I think something similar to the following, placed in the query criteria, should work:

IIf(IsNull([input box]),Like"*",[input box])

Sharon

 

[jimbo62]

That did not work. Maybe I am missing something any other ideas? Query returns nulls unless I enter something valid into one of the other fields.

Thanks,
Jim