Forms and Queries

[Graystorm2]

How do I create a form that can make queries? I need a front in form for staff to use, that allows them to run several different pre arranged queries, off the same table. Note: not at the same time. For example it can query by part number, by date ordered, by cost etc; based on my staff needs.

Even websites that explain the process would be a big help.

 

[Pampers]

There are several ways of doing this...
If they are prearrangeed query (that will give the user limited control), you could do that by using different unbound comboxes in the top of the form where the user can select its prefences, and then a submit button. The query will run and will take its parameters from the form (ic the comboxes) and showing the results in a subform.

Pampers
Keeping it simple can be complicated

 

[Graystorm2]

Thank you Pampers. Though it took me a few minutes to figure out what Comboxes are this seems to be the direction I need to go in. I am assuming at this point once I set up each combox to query its field then my staff just has to enter info and the query will run. Next step after this will be to create reports but one thing at a time

Thanks a bunch

 

[Pampers]

Yes, that is right. Crucial in this part is the query taking the parameters from the comboxes. In the query designer in the criteria field, you can use the Expression Builder Wizard, which makes it easy to point your criterium to the form comboxes. Try it with one combox first...


Pampers
Keeping it simple can be complicated

 

[Graystorm2]

I had to switch from pointing the comdbox from the query to the report to get it to print. But ran into a query problem so I have posted in the query threads. I want to tell you you helped me out big time.

 

[Pampers]

That is good to hear.

Pampers
Keeping it simple can be complicated