Cascading Combo Boxes

SteveD

Registered User.
Local time
Today, 19:40
Joined
May 11, 2001
Messages
29
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 and see if it helps.


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

Users who are viewing this thread

Back
Top Bottom