Page number problem in Access 2 reports!
Hi there,
I first have a menu of reports the user picks from, then I hide this form
which has hidden variables I can use for page counters and such. In my
reports, I ask the user what page number to start from due to the
application. I then store the page number in a text box on my hidden form.
In the page header's Onprint property, I put the code for my pageno text box
as:
Me![PageNo] = Me.Page + [Forms]![Reports]![PageHold] - 1
To automatically do this, you would probably have 2 hold fields, on open of
the report move pagestart to pagehold then add the line:
[Forms]![Reports]![PageStart] = Me.Page
This would in effect store the last page for the next report. Hopefully
this is close.
--
Willie McClure
McClure Imaginations
To reply, replace "nospam" with "isomedia"