By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,704 Members | 1,867 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,704 IT Pros & Developers. It's quick & easy.

filter problem

P: 15
How do I filter a Query in Access with multiple combo boxes on a Form, such that when selections are made from say four combo boxes at once, they work together like AND statements, but if they are left blank then ALL records are returned, so that the Query is filtered progressively by each combo box selection, and not filtered if no selection is made?
Oct 14 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Can you post the text of the query based on all cbo values being set. It can then be adapted to allow for nulls by the experts.
Oct 14 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.