Hi Saintor
Yes. Me.Dirty is the only reliable way to save a record in a specified form.
RunCommand acCmdSaveRecord saves in whatever form is active.
The wizard-generated DoMenuItem is also dependant on which form is active
(as well as what menus).
Me.Refresh does not generate any error if the save did not work, so is not
useful.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Saintor" <sa******@REMOVETHIShotmail.com> wrote in message
news:i%*********************@weber.videotron.net.. .
This is the first time I see this way of saving the actual the record. So
Me.Dirty = False does the same job as Docmd.Runcommand acCmdSaveRecord ?
First thing to check is that any changes in your form have been saved
before the export, e.g.:
If Me.Dirty Then
Me.Dirty = False
End If