Notification to change in Form Field

[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.

 

[Van T. Dinh]

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.