Saving records when a button is pushed

[LAazsx]

Hi, I don't really have experience with Access's macro so I don't really now what i need to do. I want to able to save records to tables only after when a "Save" button has been pressed.



I've been tinkering around with Access 2010's macro builder and added the SaveRecord line, but I think that this is useless since, the form will still save the record even if the button was not pressed.

[RuralGuy]

If you *must* have a "Save" button then create a Public Boolean Variable at the top of the Code Module before any procedures. Then Set it True behind your "Save" button and Save the record as well (use the CommandButton wizard to create the "Save" button). In The BeforeUpdate event of the FORM Put the following code:
If Not BooleanVariable Then
Me.UnDo
End If
...using your name for the BooleanVariable of course.