Reseting the page number after detail changes

[kshadden]

I have a report that lists medications taken by different residents. I have put the page break at the footer for each resident. However, the medications sometimes go into the 2nd or 3rd page and I want the page numbers to say "Resident A, Page 1 of 2", the next page shows "Resident A, Page 2 of 2", the next page shows "Resident B, Page 1 of 3" and so on. I can get the resident name in the page numbering but not the 1 of 2 and so on. Is there code to do this?

 

[PaulBricker]

Here's a link to a thread that should help you out.
thread703-18458

Paul