Access Forms (Stopping a form saving data)

[Adam]

Is there a way of stopping a MS access form saving data when it has been
closed?

Any help would be appreciated

 

[Allen Browne]

Cancel the form's BeforeUpdate event procedure, and Undo it:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Cancel = True
Me.Undo
MsgBox "Your changes were cancelled"
End Sub