Which is better? Using a multiselect list box to filter a query or to filter a report?
Posted on 2015-01-19
I am setting up a form in my Access database that has several multi select list boxes that are going to be used to set the criteria for a query that will serve as the basis for a report.
I have been scanning the internet trying to find the best way to do this and now I have a question for you all.
What is better? Using the list boxes to filter the query or using them to set the criteria for the report? Is there much of a difference?
I am pretty fuzzy on how to do either, but would like to see some opinions about which would be better.
Some factors may include: The query has many tables and there are multiple multiselect list boxes.
All advice is welcome!