Don't want to save forms on Refresh or closing

[accesscoder]

Hello,



I am a new access developer. I have noticed that when the form is dirty, if you refresh the form, or you press the 'cross' i.e close button on the form, it saves all the fields entered on the form, into the database. However I don't want my form to follow this default property. I want the form fields to be saved in the database, only after the user clicks the 'SAVE' button provided by me.

How can I override the default access behavior and achieve what I want?

I appreciate your help!

[evander]

Hm... I tried this silly code...

Private Sub Form_BeforeUpdate(Cancel As Integer)
    If MsgBox("Do you want to save?", vbInformation + vbYesNo) = vbYes Then
    
    Else
        DoCmd.RunCommand acCmdUndo
    End If
End Sub

[evander]

The BeforeUpdate event is triggered when you close a form.

[evander]

By the way, if you want the "saving of record" to be controlled programmatically, use DoCmd.RunCommand acCmdSaveRecord

[accesscoder]

Thank you, evander!

[evander]

Oh, you're welcome, and thanks for the reputation. It's my first time to get that one