Lost Function Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a macros to print two reports, one Legal size and one Letter
size. The second report takes information from the first report in summary
form. I've created Functions to retrieve this data and move it to the second
report. In Print Preview this works fine. When I use Print however, the
value of the Functions are lost. The only thing that seems to change is the
fact that I direct the printer to use a specific tray for the second report.
Is there a way around this problem?
 
When you preview, Access runs the events and shows the data. When you print,
it does that all over again.

You will therefore need to set up the report so that it does the same thing
the 2nd time through. For example, if you are using variables, reset them in
the Format event of the Report Header section.
 
Back
Top