Hi,

I've created a search form with a number of combo boxes on it for the user to select.
The rowsource for some of the combo boxes are filtered based on selections in other combo boxes-for example a products combo box row source is filtered dependent on the country selected in the country combo box. I have done this by simply putting names of the combo boxes in the query criteria.
They work fine, but what I would like to do
is say if no country is selected then show all products,otherwise filter the products based on the country selected.
I guess I would have to this using some fancy code? I'm not an expert on writing code-can anyone help?

I don't know if this is "fancy" or not, but have you tried typing something like this in the criteria of your query:

Like "*" & [Forms]![Yourformname]![Yourcombo] & "*"

HTH

Check this post (http://www.access-programmers.co.uk/ubb/Forum4/HTML/004099.html) and see if it helps.


[This message has been edited by shacket (edited 08-30-2001).]

Alexandre helped with this same type of issue here:
http://www.access-programmers.co.uk/ubb/Forum5/HTML/001785.html