Access Form Question using a text prompt

[B555]

I have a report that opens a from with prompts as soon as the user opens the database. My problem is sometime I need to look at two differnt inputs and sometime I need to look at only one.I use the form to input the users request into a query to run their report. I can get it to work If I enter all the Fields, But If i leave one blank the report comes back blank. I tried diff IIf statements in my query , But I can't get it to work. Can any point me in the right direction?

 

[PHV]

A common way (in a criteria cell of the query grid):
=[Forms]![yourForm]![yourControl] OR [Forms]![yourForm]![yourControl] Is Null

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

 

[B555]

PHV Thanks for help. It was so simple, I guess I was trying to over think it. It worked great! Thanks again B555