Chuck D said:
I have a report that I want to do a filter on based on what someone selects
on the form. How can I do this. Anyone one have an example of this?
If you want to offer the user lots of text boxes where they can enter
limiting values, and you then filter the report based on whatever
combination of values they choose to use, download this example and see how
to build the filter string:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
Although the example applies the filter to the the form, it's identical for
the report. It shows how to work with different field types, partial
matches, range of dates, etc.