Hi Team, I have a bounded form with many fields and I have inserted the "Save" button to save the changes with the help of MsgBox (Yes/No). The problem is when I save it, it saves the form, but later if I change/modify one field and click on "No" to undo the changes, it is reversing all the actions that were performed and saved earlier. Is there any way that it can undo the changes made only after saved?
Below is the code I have used:
Any suggestions, please...
Below is the code I have used:
Code:
If Me.Dirty Then
If MsgBox("Do you want to save the changes?", vbYesNo + vbQuestion, "Save Changes") = vbNo Then
Me.Undo
Else: Me.lbl_LastSaved.Caption = "Saved: " & Date & " " & Time
End If
End If
Any suggestions, please...
Last edited: