which event?

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
M

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
 
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?
Click to expand...

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]
 
Back
Top