Windows Vista DoCmd. Close ac Form command

[mbbearcat1981]

I am using the DoCmd. Close command to close a form. I need the form to close without saving. Essentially it will be a cancel button. The problem is that even though I have specificed acSaveNo, the entry is still saving. Has anyone seen this? Any thoughts? My code is below.

Sub Cancel_Click ()
'Cancel button for the spec form
DoCmd. Close asForm, "Project Spec Form", acSaveNo
End Sub

Thank you!
Mary Beth

 

[Madxgraphics]

I am using the DoCmd. Close command to close a form. I need the form to close without saving. Essentially it will be a cancel button. The problem is that even though I have specificed acSaveNo, the entry is still saving. Has anyone seen this? Any thoughts? My code is below.

Sub Cancel_Click ()
'Cancel button for the spec form
DoCmd. Close asForm, "Project Spec Form", acSaveNo
End Sub

Thank you!
Mary Beth

Hi Mary Beth

Welcome to the forum

I've had a look around various sites and came up with this..Either using me.undo or acCmdUndo to clear the form of any data before you close it as the data will already be commited to the databass hence still prompting you to save.

 

[mbbearcat1981]

thank you! that worked perfectly!

 

[Madxgraphics]

thank you! that worked perfectly!

Glad to be of help