Create a Grouping Level (OrderID) include a OrderID Footer.
Move everything from the Report Header into the OrderID Header.
Move everything from the Report Footer into the OrderID Footer.
Open the Properties for OrderID Footer and set Force New Page to 'After Section'.
Set the Alternate Row Color for OrderID Header and OrderID Footer to 'No Color'.


Watch this video if you haven't already: Grouping.

That fixed everything except the "Force New Page" doesn't work

Never mind, it does work!  Thank you!

You're welcome.

How would i set the field TBP to False in the print all invoices?

Update Queries

I am unclear on how/where to put this since it reads all the records in the table

What i came up with, tell me if this the best method (it seems to work).
On Close event-

Private Sub Report_Close()
    
    Dim dbs As DAO.Database
    Set dbs = CurrentDb
    dbs.Execute "orderinvallsettbpq"

End Sub