Alright, with all the good help I got it working as first described in post #1. And now I (and you) have a nice little diddy for testing report (and form) templates.
So, now I'm wondering how Access works behind the scenes. This template report uses as its data the tbl_Hr_Dept for testing.
I looked around after the wizard created a report for how it sorted (by ID), but I couldn't see where that sorting was kept.
If I want to add that now, where do I put it in this test template report? And what does it look like in the property (or whatever)?
Then I wondered, what if this report had fifty pages instead of fitting all on one page.
Does Access build the whole report at one time, or does it go get data from the table as you move from page to page?
Does reporting behavior change the way it works when you split a db? (Thinking about bandwidth and performance now.)
ReportChangeColor.accdb
The application only uses Pt1 & Pt2 for controlling the colors. Pt3-Pt5 are just used for storing color codes for easy cut&paste.