Filtering by multiple fields

[rhubarb]

I have a report form that a user can select a single filter from a list box. Items include: date, job address, etc. They highlight "Date Range," insert a date range in the boxes provided to the right and select the "Preview" button and it produces reports from that range. I want to be able to select a "Date Range" and a "Job Address." Is it possible to do this with a single list box? Suppose the user can CTRL click the fields to search by? I feel like the list box is the wrong way to go but it was good when it was a single field they wanted to filter by.



Thanks for any guidance.

[June7]

Making one listbox work for multiple criteria would be complicated.

Review these options:

1. parameterized query as report RecordSource (I am guessing you already do this with one criteria)
Can use LIKE with wildcard for multiple parameters to allow for flexibility to use any combination of parameters.
http://datapigtechnologies.com/flash...earchform.html
http://datapigtechnologies.com/flash...mtoreport.html

2. VBA code to construct filter criteria http://allenbrowne.com/ser-62.html