I have a MS access database and use it to produce simple reports. The problem i am having is when the reports go over multipages my public variables are cleared and start calculating from the information on the start of that page.

They are declared at the top of the form VBA section as shown below.

Option Compare Database
Public intTotal As Long
Public intTotVis As Long
Public intTotAmex As Long
Public intTotBC As Long
Public intTotDC As Long
Public intTotRef As Long
Public intTotFailed As Long
Public intTotMS As Long

Any ideas of were i can store these so that they will keep totals from all pages of the report just not the first one.

I am passing information into them via another function.

Thanks

Vanny