Report Query criteria with dropboxes instead of text boxes...

[tanyalee123]

I am creating a whole slew of reports, and many of them have 3-4 criteria that need to be entered to run the report. My reports are, of course, based on queries. Is there a way to have a dropbox for the some of the criteria instead of just a text box that the user types in? Of course, without a dropbox, the user runs the risk of not entering the information correctly and thus the report not running. I would rather provide the correct options.

Similarly, is there a way that a form can pop up where the user can enter all of the criteria required for the report instead of having message boxes pop up several times. It would just be a cleaner look for those reports that have several criteria. I tried basing a form on the query, and tried basing a form on the report, but both didn't yield me any results; obviously it's not that simple.



Any help is appreciated!! Thank you!

Tanya

[June7]

Yes to all. Options:

1. dynamic parameterized query references the form controls for input, review: http://datapigtechnologies.com/flash...mtoreport.html

2. use VBA to construct filter criteria string, review: http://www.allenbrowne.com/ser-62code.html
instead of applying string to form Filter property, use it in the DoCmd.OpenReport method

[tanyalee123]

Thank you! The video is great, I think I can do it that way.

[tanyalee123]

Where is the solved?

[June7]

Thread Tools dropdown above first post.