Query Criteria

[Theresa]

Hi:

I am using Access 2007. I have created a report based on a query with 1
criteria. When the report runs a box asks the user to enter the project
name. I have a couple of different reports that use the same query and
therefore require the same criteria. I would like to have all the reports
open from a command button, which I think I kno whow to do, but I would like
the user to only have to input the criteria once. Is this possible?

Thanks,

 

[Jeff Boyce]

If your "requirement" is that the user only enter/select a criterion once,
then consider creating a form in which s/he enters/selects that criterion.
Then add a way to launch the report, make the report depend on a query, make
the query depend on (i.e., "look at") the form for its criterion. ?Run a
different report? Point its query at the form!

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Theresa]

So if I create a form to enter the criteria, can I have a number of different
reports open at the same time using this same criteria?

 

[Jeff Boyce]

I'm not sure what you mean by "having all the reports open at the same
time"...

.... but if you add a command button on the form, and enable it only after
the user entered/selected a criterion, and behind that button added
something like:

DoCmd.OpenReport "Report1"...
DoCmd.OpenReport "Report2"...
...

then I think it would do what you're describing...

Regards

Jeff Boyce
Microsoft Office/Access MVP