Form used as input for query requests

[Gunilla]

Hi
I have a form that I want to use as an input device for a query request. The form has 4 fields.
cboUser (A combobox with the users name),
cboProv (A combobox populated with names from a table)
txtFrom (a textbox where the from-date is entered)
txtTo (a textbox where the to-date is entered)

Now to my question.
I want the user be able to enter something from the list in either both of the comboboxes or just one of them. The dates are populated when the form opens.

So this is what I want the query to do when I click on the button open query:
If the cboUser is Null then cboUser="*"
If the cboProv is Null then cboProv="*"
I am enclosing an image of the part of the query where I need to place the requests.
I suppose I should use the IIF is null, but I don't know how.

 

[ajetrumpet]

try this as part of your query sql:

WHERE ([field1] = forms!form!cboprov or forms!form!cboprov is null)

AND

([field2] = forms!form!cbouser or forms!form!cbouser is null)

AND 

the rest of your form references here....

you might also gain some knowledge here:

http://www.access-programmers.co.uk/forums/showthread.php?t=183254

 

[Gunilla]

Thank you
I knew I could count on the forum's Gurus.
Happy Easter