Passing Multi parameter values to a query

[P_Henry]

I have a query set up which needs to have different criteria at run time depending on values selected by the user. If no option is specified, I need to pick up all records with 'Nulls' in them else, if date is specified by user, I need to pick up all records with date > than specified date. The query is able to pick up the date value from an unbound text box in the form. I used the same field in the form and populated "Is Null" in the field and it does not work. How do I pass this as a paramater to the query from the form?
Is there a way around without setting up 2 sets of queries and reports?

Thanks,Priya

 

[ThreeCrow]

I think that I know what you want to do


If no date range is chosen you want to show records that the date value is Null.

Or is the Null value in another field.

 

[P_Henry]

Yes...If no date is specified, I want all records with Nulls in the date field to be displayed in the report. The date gets populated when an event happens in another field. Hence, not all records have dates populated

 

[P_Henry]

Thanks Pat,

When I did this, the query introduced the field from the form in the query and set the criteria as 'Is Null' for the field.
It works fine now...
Priya