Notification to change in Form Field

  • Thread starter Thread starter Sondra.
  • Start date Start date
S

Sondra.

I have a form that has some information pre-entered when
the user opens the form. I have locked the fields that
the user should not be allowed to change; however I have a
field that the user can change if necessary. I want to be
able to run macro to send an email to the orginator of the
pre-entered data to let them know of the change. Does
anyone know how I might run a macro from the field that
sends out an email as soon as the change is made.

I have created one, but it outputs the original data
versus the new data. Is there a way to have the output
show the new data entered in the form without required the
orginator to open the form???

Thanks.
 
Try using the TextBox_AfterUpdate Event

You will need to code the Value of The TextBox into the Body of your e-mail
as this Value is not yet stored in any Table.
 
Back
Top