Cancelling update

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 13 Jan 2008 20:20 GMT

Hi

I am setting Cancel = true in BeforeUpdate event of a form but the edits by
user still stay there. How can I undo user edits on the form?

Many Thanks

Regards

Reply to this Message

Dirk Goldgar - 13 Jan 2008 20:29 GMT

> Hi
>
> I am setting Cancel = true in BeforeUpdate event of a form but the edits
> by user still stay there. How can I undo user edits on the form?

In addition to setting Cancel = True, undo the form:

Cancel = True
Me.Undo

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Arvin Meyer [MVP] - 13 Jan 2008 20:29 GMT

Just before the Cancel = True line in your code, add the line:

Me.Undo

That will undo the record, and cancel the save, but you will still use an
autonumber, if that concerns you.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Hi
>
[quoted text clipped - 4 lines]
>
> Regards

Reply to this Message