print preview not same as printed report

J

jkherman

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
 
D

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top