force new page for each header data 2

[TimTDP]

In Access 2000, I have a report that contains a:

Report Footer
Invoice Date Header
Delivery Driver Header
Detail
Page Footer
Report Footer

I currently individually select each delivery driver and print the report for that driver. I now want to create a command button that prints all the delivery reports. I want to keep the the entire print out as a single report, but with a page break after each driver. Each driver must get all the above detail on his report because I need to e-mail it.

What is the best method to achieve this?

 

[TimTDP]

That did it!

Added text box, set visible = No and the code runs perfectly.

Many, many thanks
I would give you 10 stars if the system allowed me too.

 

[Eutychus]

I used the above code with slight modifications in an Access 2007 report, and it worked well. However, I had to put the code in the OnFormat area of the Page Header section; otherwise, the group name change was recognized too late. Maybe this location of the code will help others, too. Thanks!

 

[joebb3]

Nice! I've been looking for this! Star for dhookom!

Page of Pages IS required for the script to work...