Disable auto record save

[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

 

[Allen Browne]

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