Access Forms (Stopping a form saving data)

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

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

Any help would be appreciated
 
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
 
Back
Top