Report not printing modified data

J

jped

Hello, I have created a purchase order system. When the user creates a new
order and prints out the information, it works fine. However, when they go
in and modify an old order and try to print it out, it does not print out the
new information unless they close it and reopen it. Then it shows the new
data and they can print the report. Is there a way that when they click on
the print button it will save the changes and show that in the report they
are about to print? Thanks for your help!
 
R

Rick B

You need to save the changes to the record before you print.

modifying your code to include something like this should do it...

Private Sub cmdPrint_Click()

If Me.Dirty Then 'Save any edits.

Me.Dirty = False

End If
 
F

fredg

Hello, I have created a purchase order system. When the user creates a new
order and prints out the information, it works fine. However, when they go
in and modify an old order and try to print it out, it does not print out the
new information unless they close it and reopen it. Then it shows the new
data and they can print the report. Is there a way that when they click on
the print button it will save the changes and show that in the report they
are about to print? Thanks for your help!
Click to expand...

Access does not save new data until you navigate to another record,
close the form, or expressly tell it to save the data.

Code your print command button:

DoCmd.RunCommand acCmdSave
DoCmd.OpenReport "ReportName", acViewPreview
 
J

jped

Sorry it took so long to get back to you, but that worked great! Thanks for
your help!
 
Top