Notifying Users of Changes to a Form

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

Sondra

In some circumstances I need to notify Specific Users that
data has been entered into a form. When the form is
originally brought up fields are empty and the user will
fill in those that are needed. If a particular field is
entered into then I must send notification to another
user. I want to create a way to send an automatic email
to the other user that the data has been entered; however
if the field is null or has not been changed, I want to be
able to bypass the email notification. Is this possible
with a macro? Or can I write an expression that would
have an Iif statement with a macro.

Thanks for all your help.

Sondra
 
Sondra,

You can use a SendObject macro to send the email, and assign the macro
to the AfterUpdate event property of the control in question on the
form. There is probably no need for a Condition on the macro, because
the AfterUpdate event only happens when there is a change to the data
in that control.

- Steve Schapel, Microsoft Access MVP
 
Steve:

I assume your suggestion will work even if the entry user
just tabs past the field???

Thanks

Sondra
 
Sondra,

Depends what you mean by "works". You originally stated that you
don't want an email sent if there is no entry made in ther control
(please note that forms don't have fields or data!) If they just tab
past the control, there will not be an AfterUpdate event, and
therefore no email will be sent.

- Steve Schapel, Microsoft Access MVP
 
Back
Top