Hi! I'm new here, so I'll give a quick introduction before asking my question.
I'm brand-spanking new to Access (2010 to boot), and am pretty excited since I got it this past weekend. I've created my first relational database, it's first form, a couple of macros, a couple of queries and reports based on those queries. I'm sure I've broken more than a few "This probably isn't the best way to do it..." rules, but so far everything seems to work alright. Except the stupid custom navigation buttons, but they're low on my priority list.
/uninterestingstuff
I wasn't sure which board to post this question on since it seems to touch on a bit of everything. So here it is, and I'll try to be as specific as possible:
Is there any way to let a user use a form to generate a query using a predetermined list of criteria, and then automatically generate a report from that query?
Basically what I intend for a user to be able to:
* Open a form
* Type or select criteria using textfields and/or combo/dropdown boxes
* Submit the criteria
* AccessMagically have a report open in front of them with only the table entries that match the submitted criteria
Please keep in mind that I'm pretty new to Access and databases, so I'm still pretty reliant on the GUI to 'translate' my instructions. Let me know if I need to provide more detail.
Any help with this would be awesome, and thanks in advance!