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'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?