Oct 21 2005, 07:32 PM
I noticed in MS Access after fill up all the fields in a form, the record is autosave, Is there a possible way to avoid this. I want to ask the user if he want to save the record or not.
Oct 21 2005, 07:43 PM
If the form does not contain a subform .. you could do this using the Before Update event of the form ....
Oct 21 2005, 08:11 PM
Like Ricky said if the form does not have a subform.
You could use the following
Place a Command button on the form and call it SaveCmdBtn
In the OnClick event of the this Command Button use the following in a Procedure
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
In the OnClose Event of the Form use the folowing in a Procedure
DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
Oct 21 2005, 08:21 PM
The "DoMenuItem" method is somewhat obsolete .. although it still works in the latest version of Access ...
It may not be supported in future versions ...
There are better methods and properties that can be used to do this task ...