Saving a Record Edit ONLY if button is clicked?

[McArthurGDM]

Hi all,

Typically, if I want to edit a record I just create a formed linked to a table or query, make my change to the record, and move on with life. However, I want to make it so that the change ONLY takes effect if you click a button that says something like "Save Record".

How do you accomplish this?



Thanks

[JoeM]

Then you may want to use an Unbound Form, and have the button run an Update or Append query to update/add the record.

Or, you will need to figure out how to "undo" the changes if the button is not pushed. See Bob Larson's post here: http://www.access-programmers.co.uk/...42&postcount=6

[McArthurGDM]

Thank you!

Perfect. I had to change a few typos, but for the most part it worked. Also, it would be advisable to turn warnings off and then on back again at the beginning and end of the code, respectively.

Thanks again!

[Micron]

Looks simple enough, but I don't think it would work for a form with multiple records (continuous form or datasheet). Each time you move to a new record, the form is updated and you'd have to respond to the message. In these cases, I use a temporary table with a boolean variable in the module declarations section to flag the form as dirty (since it is dirty no longer if you move to a new record after an edit). Does anyone have a better method?