I have tables and queries in Access with Crystal Reports as the reporting tool. I need an easy user interface with about 10 drop down boxes for selecting the criteria to pass to the query. Can I do this in vba? The problem occurs if a user does not make a selection in one of the combo boxes - in which case, I want the query to return all for that criteria. Thanks for any help in this matter.
