how do i reset the page number in Access when a value changes?

W

whilburn2005

i am creating an ACCESS report and I need to have the page number reset to 1
when a field value changes. how do i do this?

thanks.
 
M

Marshall Barton

whilburn2005 said:
i am creating an ACCESS report and I need to have the page number reset to 1
when a field value changes. how do i do this?
Click to expand...


To determine when a field value changes, use Sorting and
Grouping (View menu) to specify the field. Also set it to
include a group header section.

Now, you can set the group header section Force New Page
property to Before Section to start a new page when the
value changes. The header section's Format event procedure
can then be used to (re)set the page number using a line of
VBA code:
Me.Page = 1
 
Top