Report using Form

[AN60]

I want to use a form to enter criteria on a query then view a report based on the query. At the moment I do something like that with a calendar & dates. Is what i want possible?

 

[Jaydeebe]

I want to use a form to enter criteria on a query then view a report based on the query. At the moment I do something like that with a calendar & dates. Is what i want possible?

Hi,

You can create a parameter query (a query that asks for criteria to search by) and a report based on that query. I have a form with a command button. Clicking the button runs the report. Because the report is based on a parameter query it will ask the user for input before running.

Hope this is of help to you.

Regards

 

[neileg]

Not just possible but an every day technique.

As Jaydeebe says, base the report on a parameter query. Enter the full name of the control on the form that holds your parameter into the criterion box in the query grid. For example Forms!frmMyForm!txtMyControl

Make sure the form is open when you run the report. I usually attach the report to a button on the form to achieve this.

 

[AN60]

Thank you for your prompt replies. Since I posted my original question I have searched more and found what I wanted and have it working. The site below has some good hints on it.
http://www.fontstuff.com/access/acctut08.htm