Access Forms (Stopping a form saving data)

A

Adam

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

Any help would be appreciated
 
A

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
 
Top