Query Criteria

  • Thread starter Thread starter Theresa
  • Start date Start date
T

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,
 
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
 
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?
 
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
 
Back
Top