email a list from an updated field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to to send an e-mail to someone once a field has been updated or values put in
And would there be a way that I can query if something has been put in
Could I query based on the date in a field and the cuurent date. This could give what has been updated at that time

Does anyone have any suggestion
 
It depends on how their entering the data, if it's a form you can assign the field you want to test to a variable and then if that changes send an email or in the properties box just put the email code in there for on change, make sure to set a value.oldvalue and test it to the new value first so you don't send tons of emails. If they open the database table itself you can create similar code that opens the database and assigns the field to a variable and then watch if it changes.

The easiest way is to use a form and then just put your email and validation code in the on update or on change event.
 
Back
Top