Saving record before printing

[Guest]

I posted this question on Friday but it's nowhere to be found now....

I have a form based on a recordset which is filtered one record at a time.
I have a PRINT button on the form. When the print button is pressed I want
to print the record including any changes not written to the table yet. So
directly before opening the report I need to save the record.
I have tried both:-
docmd.save
and
docmd.RunCommand acCmdSave

Neither results in the current changes being printed.
Where am I going wrong?

 

[Allen Browne]

That should work.

Here's a more complete example:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

 

[Douglas J Steele]

Try using Me.Dirty = False