Sending email when a field data is changed

[gsrajan]

I have to send an email when the data is changed in a specific field ( for example, a field data is changed from "Pending" to "Paid".

Please let me know how to do this.

Thanks for your help.

 

[arnelgp]

if you are on data entry form, you can trigger the AfterUpdate of that specific field.

private sub yourFieldName_AfterUpdate()

If Me!yourFieldName.Value <> Me!yourFieldName.OldValue And _
Me!yourFieldName.OldValue & "" <> "" then
MsgBox "Status of field has changed from " & Me!yourFieldName.OldValue & _
" to " & Me!yourFieldName.Value
' do the rest of code, or email if you want
End If
End Sub

 

[Ranman256]

in field name AFTERUPDATE

DoCmd.SendObject acSendReport, "rptAlert", acFormatPDF, "name@aol.com", , , "field update", "Your field changed"