Use Form to Get Criteria for Query to Create Report

[gjcomom]

Hello, I'm having issues in that I really don't know where to start to even search for an answer to my problem.

I want to create a form that allows a user to enter criteria that will be passed to an existing make table query.

Is this possible? I hope so, but I've been searching online for an answer and I can't seem to find exactly what I'm looking for.

Would greatly appreciate any help? Also, if anyone has suggestions on a user friendly book on Access 2010 programming, I'd be really interested. I'd like to be able to do more with Access 2010.

Thank you.
GJCOMOM

 

[jdraw]

It's difficult for readers to respond since your post is s vague. Can you tell us more about the database? What is it for? Who uses it? What is the subject matter involved? Why do you need make table queries? You can build one or many forms, but what does the form represent? Usually a form is a means of interacting with the data that is stored in tables.

The more you can describe what you are dealing with, the better your chances of getting meaningful responses.

Good luck.

 

[gjcomom]

Thank you for your review of my post. I'll break it down some more.

1. I have a query already built that doesn't have any criteria built into it, because the criteria can change with the type of information that a user is looking for.

2. Rather than have users who are not familiar with Access trying to input the criteria they need on a report into the design view of a query I would like to utilize a form.

3. I would like to find out if it is possible for a user to enter the criteria they are looking for in fields on a form and have a table open when the records that match that criteria when the user clicks submit on the form. (To me it is kind of like parameter queries. But, I just want it in a form instead having the query asking the user one question at a time.)

Thanks.

 

[weeblebiker]

read the post I just made on this board
"(2007) easiest way to include query criteria in a query form"