The Undo event executes before changes to a row are undone. : Form Events « Forms « VBA / Excel / Access / Word






The Undo event executes before changes to a row are undone.

 
Private Sub Form_Undo(Cancel As Integer)
     If MsgBox("You Have Attempted to Undo Changes " & _
         "to the Current Row.  Would You Like to Proceed " & _
         "with the Undo Process?", _
         vbYesNo) = vbYes Then
         'If he responds yes, proceed with the undo
         Cancel = False
     Else
         'If he responds no, cancel the undo
         Cancel = True
     End If
End Sub

 








Related examples in the same category

1.Writing the Form_Error Event Procedure
2.Assign form Recordset in its open action
3.CancelEvent: DoCmd.CancelEvent()
4.IsLoad function
5.Form Before Update action
6.Key down event
7.If the data in the form dirty
8.Form_Filter
9.You can not only check how the filter was invoked, but you can also intercept the process when the filter is applied.
10.The Load Event Assigning a Recordset Object to the Form
11.Code for the Move Previous Button
12.Code for the Move Next Button
13.Code for the Add Button
14.Deleting a Record
15.Code for the Find Button