Hi,
I have a query that I want to filter from 3 combo boxes on a form. My problem is that I want the filter to filter on the value in each box, or if th box is blank (ie, no selection made), to not filter at all. I am currently using the criteria section of the query.
To expand a bit further - there are 3 combo boxes. The filtering could be any combination of these - ie, up to 7 possible combinations of filter. Rather than having a separate query for each combination, I'd like to 'smart' the one query to do this properly.
Thanks for any help!
I have a query that I want to filter from 3 combo boxes on a form. My problem is that I want the filter to filter on the value in each box, or if th box is blank (ie, no selection made), to not filter at all. I am currently using the criteria section of the query.
To expand a bit further - there are 3 combo boxes. The filtering could be any combination of these - ie, up to 7 possible combinations of filter. Rather than having a separate query for each combination, I'd like to 'smart' the one query to do this properly.
Thanks for any help!