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

"John" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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



--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"John" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>