How do I set page number by group???

[higheriq]

I've tried at least a dozen different suggestions and so far nothing has worked. I'm using Access 2007 and trying to get page numbers to re-set after each group. I've tried the code on this site:

http://access.mvps.org/access/reports/rpt0013.htm

but it does not work. The page numbers either still number the entire report ( pages 1 of 84, pages 2 of 84, etc.) or the page numbers do display at all. Dows anyone have any other suggestions?

 

[dhookom]

There are a number of solutions on the web including How to reset the page number on a group level in an Access report

Duane
Hook'D on Access
MS Access MVP

 

[higheriq]

Thanks - That's one of the articles I've tried but it also does not work. I'm curretly trying (again) the suggestion at

http://www.utteraccess.com/forum/Page-Nubering-Group-t1966621.html

but I'm getting a compile error on the GrpNameCurrent = Me!Dealer Name (where Dealer Name is in place of MyGrouField.

 

[higheriq]

I got it to work by using these instructions:

http://www.tek-tips.com/faqs.cfm?fid=2307