Jamie

Just a thought, but if you removed the parameter that prompts for the
employee, then modified the report to put each employee's data on a separate
page, would that accomplish what you're after?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Jamie Dickerson" wrote in
message ...
I have a report based on a query. On opening the report you are prompted
to
enter 3 parameters (start date, end date, employee name). I need to run a
seperate report for each employee. Is there anyway to code or create a
macro
that tells the report to reopen with new parameters upon closing or
printing.
I am trying to avoid opeing the report 80 times.