Closing Form Save Option

[dweekley]

I currently have your basic If you want to close Yes\No setup.



If MsgBox("Are you sure you want to exit?", vbYesNo + vbQuestion, _
"Exit Dialog") = vbNo Then
Cancel = True
End If

But I am thinking that if the form has changes that the user should have option to save then or continue with closing the form. Not sure if this would cover that. If so, I believe above the exit dialog.

If Me.Dirty Then
If MsgBox("Do you want to Save?", vbYesNo + vbQuestion, "Save Record") = vbNo Then
Me.Undo

End If


TIA

[aytee111]

You won't need the Do you want to close question, only the Save. If a user hasn't made any changes then it doesn't matter if they close the form.

The OnClose event does not have the ability to cancel, is this in a close button?

[dweekley]

The exit dialog is on the UnLoad so it can be cancelled.

I moved the Me.Dirty to BeforeUpdate and seems to be working fine.