Exit button without saving data

[uoghk]

In Form, Textbox's Control Source set to table's field.
When I close the form, the entered data is saved automatically.


But, how can I code the Exit button to close the form WITHOUT saving any data?
Thanks.

[Bob Fitz]

In Form, Textbox's Control Source set to table's field.
When I close the form, the entered data is saved automatically.
But, how can I code the Exit button to close the form WITHOUT saving any data?
Thanks.

Perhaps something like the following code in the form's BeforeUpdate event.

If Me.Dirty Then    
    If MsgBox("Exit without save?", vbYesNo, "Confirmation Required") = vbYes Then
        Me.Undo
    End If
End If

[uoghk]

Thanks Bob