Save Data before Printing

[mattc66 via AccessMonster.com]

Hi All,

On my main form I have a print button that generates a report based on the
data on my form. However if the user makes a change to the data and then hits
print the change is not reflect until he closes the form and then open it
again. So I added the DoCmd.Save to the Print button. This still didn't seem
to fix my problem.

What can I do?

 

[Rick Brandt]

Hi All,

On my main form I have a print button that generates a report based
on the data on my form. However if the user makes a change to the
data and then hits print the change is not reflect until he closes
the form and then open it again. So I added the DoCmd.Save to the
Print button. This still didn't seem to fix my problem.

What can I do?

Me.Dirty = False

DoCmd.Save is for design changes, not data.

 

[Guest]

Hi Matt...

Insert the following code before opening your report:

if me.dirty then
docmd.runcommand accmdsaverecord
end if

Hope this helps.

Damian.

 

[fredg]

Hi All,

On my main form I have a print button that generates a report based on the
data on my form. However if the user makes a change to the data and then hits
print the change is not reflect until he closes the form and then open it
again. So I added the DoCmd.Save to the Print button. This still didn't seem
to fix my problem.

What can I do?

DoCmd.Save only saves design changes to the form, not the record data.

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "ReportName",acViewPreview

 

[mattc66 via AccessMonster.com]

Thanks that was it..

Hi All,

[quoted text clipped - 5 lines]

What can I do?

DoCmd.Save only saves design changes to the form, not the record data.

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "ReportName",acViewPreview