Alright guys,
I've built a pretty simple Access database that my office uses to keep track of returned checks. My users are computer novices, so I try to follow KISS as much as possible when building the interface.
I have a form: frm_UpdateNFS that pulls in records via query: qsel_UpdateNSF. The query prompts users via pop ups from the criteria of Last Name, Check Number, and Barcode, each with its own parameter box, which causes some of my power users to misstep when trying to lookup the record when someone is on the phone.
What I am looking for is the ability to create something like an advanced query that pulls from a form or something????!?!?! I'm attaching a screenshot of an interface we uses for our student information system, that I would like to be able to base my advanced search on.
I have no idea how to go about doing this, as I am rather a access novice myself. So I may need some in depth steps on some of this.