don't save record unless I click save

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Harry - 30 Aug 2006 00:42 GMT

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?

Reply to this Message

Larry Linson - 30 Aug 2006 01:04 GMT

>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
[quoted text clipped - 5 lines]
> 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

Reply to this Message