Reset an Undo

[Leslie]

On a form, I create a record and save, and am ready to enter another.
I decide to Quit the form which executes an "Undo" in case there is
data entered. This then tries to "delete" my just saved record.

I want to "Reset" my Undo ability once I've saved a record. Is there a
way to reset the Undo?

Any help or tips would greatly help. I'm looking for syntax and
attachment points.

Cheers,
Leslie

[Allen Browne]

In whatever event you are using to perform your "undo", test if the form is
Dirty first:

If Me.Dirty Then
If MsgBox("Undo?", vbYesNo+vbDefaultButton2) Then
Me.Undo
End If
End If

Perhaps the real solution might be not to dirty the form as soon as you move
to the (new?) record.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Leslie" <le*****@oregonaero.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

On a form, I create a record and save, and am ready to enter another.
I decide to Quit the form which executes an "Undo" in case there is
data entered. This then tries to "delete" my just saved record.

I want to "Reset" my Undo ability once I've saved a record. Is there a
way to reset the Undo?

Any help or tips would greatly help. I'm looking for syntax and
attachment points.

Cheers,
Leslie

[Leslie]

Allen,

Thank you very much. I think you have the answer I'm looking for. I
had been looking at the "Dirty" option, but I was unsure of how to
execute it with the Undo. I think your suggestion will work well with
what I'm trying to do. Sometimes you just need to banter stuff with
folks and then the light comes on.

I was hoping there was an Undo.Reset or Undo.Init or something like
that that I could put at the end of my save, but your solution seems
like it will work just fine.

I will give it a try on Monday when I return to work. Thank you.

Cheers,
Leslie