Looking for alternatives to Form_Close (1 Viewer)

[JC10001]

Hi guys,

I have a form with a few text fields in it. What I want to do is have a msg box pop up if the user leaves the form and the form is dirty. The msg box would then give the user the opportunity to save the changes or cancel before moving to the next form.

What I've done that works, is place the code into the click events of all of the buttons on the form. This gets the job done but it also needlessly duplicates code. I then tried to do the same thing with a form_close event and the form just closes and saves the changes without prompting the user first.

Are there any form events that will allow me to do what I would like to do or will i just have to place all of the code into a function and then place a call to that function in each buttons' click events?

Thanks.

 

[Mile-O]

Private Sub Form_BeforeUpdate(Cancel As Integer)
    If Me.Dirty Then
        If MsgBox("Would you like to save the changes?", vbQuestion + vbYesNo, "Save Changes?") = vbNo Then
            Cancel = True
        Else
            DoCmd.RunCommand acCmdSaveRecord
        End If
    End If
End Sub

 

[Fuga]

What does it mean when a form is "dirty".

Fuga.

 

[JC10001]

Thanks Mile.

 

[JC10001]

What does it mean when a form is "dirty".

Fuga.

It means that one of the text fields has changed. The form has been altered, tainted, therefore dirty.

 

[Fuga]

Ok, thanks. Didn´t know that.

Fuga.

 

[Rich]

You don't need to test for Dirty, the Before Update Event of the form will only fire when the form is dirtied anyway