Printing First and Last Page Numbers for Report Groups.

[jmstarbuck]

In an old thread (thread703-1563912) dhookom (Programmer) posted this link to code for keeping track of page numbers by group in a report:

http://www.mvps.org/access/reports/rpt0013.htmPrinting

This looks like just what I need, but I am having problems.

Me.Pages is always = 0 for me, so I don't get the page counts. Is there something I need to define in my report for this to work? Is this supported by Access 2003?

I've really never tried to do anything with code behind a report before, so any help would be appreciated.

Thanks.

 

[jmstarbuck]

Update, The good news: I added a reference to [pages] to my report and now the me!pages is working.

The bad news: Now I am getting subscript out of range on both arrays - on the first and subsequent pages.

Any thoughts?