print preview not same as printed report

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

Guest

Hi -
I am using a form to provide report criteria. When I preview the report,
everything looks fine, but when I print the report, it is missing some of the
data that was entered on the form specifically for the report. The data that
is missing is the data that was entered on the form but this data is not
stored anywhere.
Here is the code, when you click OK on the form, the preview of the report
pops up. When I print this report, it is missing some parameters. Should my
code read differently?

Private Sub OK_Click()
Me.Visible = False
DoCmd.OpenReport "Silver Oxide Type I - Certificate of Analysis",
acViewPreview

DoCmd.Close acForm, "Certificate of Analysis Input"

End Sub
 
Don't close the form if you expect to use information from the form. You can
set it to invisible.
 
Back
Top