How can I change the starting page number of a report?

[Shirlo]

I have a document that is printed in multiple reports. In the 2nd report, I
want the first page number to be 5.

 

[Marshall Barton]

I have a document that is printed in multiple reports. In the 2nd report, I
want the first page number to be 5.

Use the page header (or footer if you don't have a page
header section) section's Format event to reset the page
number:

If Me.Page = 1 Then Me.Page = 5

 

[Shirlo]

I guess I need more info. I tried putting your statement in the ON FORMAT
line of the EVENT tab in the page header properties, and it says it can't
find a macro ME.

 

[Rick Brandt]

I guess I need more info. I tried putting your statement in the ON
FORMAT line of the EVENT tab in the page header properties, and it
says it can't find a macro ME.

In that box drop down the list of choices and choose [Event Procedure].
Then press the build button [...] to the right of the box. That will take
you to the VBA editor window and that is where you put your code. Access
will automatically create the lines that define the start and end of the
code block. Your line(s) need to go between them.

 

[Marshall Barton]

Rick answered the question, but I want to add that you
should not confuse the event **properties** and the event
**procedures**. The event properties are used to indicate
how an event is connected to the corresponding event handler
macro, VBA function or event procedure.