asked on
Private blnSaved As Boolean
Private Sub Form_BeforeUpdate(Cancel As Integer)
If blnSaved = False Then
Cancel = True
Me.Undo
Cancel = False
End If
End Sub
Private Sub Form_Current()
blnSaved = False
End Sub
Private Sub btnOK_Click()
blnSaved = True
MsgBox "Changes saved!"
End Sub
Private Sub btnCancel_Click()
DoCmd.Close
End Sub