which event?

[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

 

[John Vinson]

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]