Disable auto record save

  • Thread starter Thread starter Allie
  • Start date Start date
A

Allie

Is there a way to only have Access save a record if a save
button in pressed, instead of the auto save feature it
currently has?

Thanks
 
In the General Declarations section of your form (top of module, with Option
statements):
Dim bAllowSave As Boolean

In the Click event of your command button to save:
If Me.Dirty Then
bAllowSave = True
Me.Dirty = False
bAllowSave = False
End If

In Form_BeforeUpdate:
If bAllowSave Then
bAllowSave = False
Else
Cancel = True
MsgBox "You can save only by clicking the button.
End If
 
Back
Top