I want to do a query with criteria picked up from a form. Sometimes the form will request one particular value for the criteria, other times it will request all values. I am setting the criteria feld on the query with Forms!Formname!Fieldname. It works when one value is selected, but doesn't seem happy with *, Like "*", null etc. or anything other than a simple value. I realise I could use two queries, but what I really want to do is to have 3 or 4 criteria fields of this type and I don't want that many queries!

Any ideas?

The article below holds the answer to your question...

http://support.microsoft.com/support/kb/articles/Q210/2/42.ASP?LN=EN-US&SD=gn&FR=0&qry=QBF&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000