which event?

25 Feb 2005 7:15 PM

mcnewsxp

my form has a button the puts it in to add new record mode.
the caption of the add button changes to say Save New Record.
which event do i trap if the user moves off the new record and wants to
cancel the addition.
i need to set the button back to say Add New Record.
is there a way to detect when navigation buttons are clicked or something
better?

tia,
mcnewsxp

25 Feb 2005 8:26 PM

John Vinson

On Fri, 25 Feb 2005 14:15:32 -0500, "mcnewsxp"
<mcour***@mindspring.com> wrote:

>my form has a button the puts it in to add new record mode.
>the caption of the add button changes to say Save New Record.
>which event do i trap if the user moves off the new record and wants to
>cancel the addition.
>i need to set the button back to say Add New Record.
>is there a way to detect when navigation buttons are clicked or something
>better?

A couple of choices: the Form's BeforeUpdate event would be the most
appropriate, I'd guess. It fires when the user leaves an edited record
and can be cancelled. The form's Current event fires whenever you move
to a different record (but the edits will have already been saved,
requiring a delete query to remove them).

John W. Vinson[MVP]