Form for Parameter query

D

Dragon

I'm looking for some solid, easy-to-understand information or perhaps a
tutorial on how to create a form linked to a parameter query or queries.
Ideally I would like to link up the required queries into one form that then
generates a report based on the queries.

Right now, I have the report set up with the source being a parameter query.
I also have 4 sub reports that the sources are other parameter queries.

Thanks in advance,
Dragon
 
J

John W. Vinson

I'm looking for some solid, easy-to-understand information or perhaps a
tutorial on how to create a form linked to a parameter query or queries.
Ideally I would like to link up the required queries into one form that then
generates a report based on the queries.

Right now, I have the report set up with the source being a parameter query.
I also have 4 sub reports that the sources are other parameter queries.

Thanks in advance,
Dragon

Some folks have sample databases but the basics are really very simple.
Instead of a parameter criterion such as

[Enter start date:]

use a criterion

[Forms]![CriteriaForm]![txtStartDate]

CriteriaForm should be open at the time you launch the report; it's convenient
to just use an unbound Form and put a command button on it to open the report
(the command button wizard will help with this).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top