don't save record unless I click save

I have been entering info in my form with no problem. I closed the form and
went to something else and then came back to the form. I noticed that Access
saved what I typed even though I didn't tell it to. This is also a problem
when accidentally editing an existing record. I really have to keep an eye on
what I'm doing. I want to keep Access from saving a record unless I click a
Save button. How can I do that?

"Harry" wrote in message
...
I have been entering info in my form with no problem. I closed the form and
went to something else and then came back to the form. I noticed that
Access
saved what I typed even though I didn't tell it to. This is also a problem
when accidentally editing an existing record. I really have to keep an eye
on
what I'm doing. I want to keep Access from saving a record unless I click
a
Save button. How can I do that?

You can put code in the BeforeUpdate event of the Form to Check if you have
set a variable due to clicking a Save button, or also in the BeforeUpdate
event, you can use the MsgBox function to communicate with the user, asking
if he/she really desires to Save.

That said, Access saves the Record automatically under a number of
conditions and most people learn, not only to live with that, but to like
it.

Larry Linson
Microsoft Access MVP