Simple question about Cancel Event

In a check box's "before update" event, if I have an "are you sure" yes/no
message box with Cancel = True set if the "no" button is clicked, how do I
simulate pressing ESC to "un-dirty" the record? I should know this but I'm
having a bit of a lame-brained Monday.

Many thanks.
Keith.

re: Simple question about Cancel Event

Me.Undo

--
Wayne Morgan
MS Access MVP


"Keith" <keith.wilby@baeAWAYWITHITsystems.com> wrote in message
news:431c5577$1_1@glkas0286.greenlnk.net...[color=blue]
> In a check box's "before update" event, if I have an "are you sure" yes/no
> message box with Cancel = True set if the "no" button is clicked, how do I
> simulate pressing ESC to "un-dirty" the record? I should know this but
> I'm having a bit of a lame-brained Monday.
>
> Many thanks.
> Keith.
>[/color]

re: Simple question about Cancel Event

"Wayne Morgan" <comprev_gothroughthenewsgroup@hotmail.com> wrote in message
news:jXZSe.337$zq6.21@newssvr27.news.prodigy.net.. .[color=blue]
> Me.Undo
>[/color]
Uh, that simple? Thanks Wayne.