Notification / alerts for data change

[engr_saud1]

Good Morning Experts !


Can some one tell me the syntax for finding a change /update in a table. I want to add a data macro to my table "After update" , to send email to group as soon as a new DB entry is made in the table

[rpeare]

I don't believe you can do that at the table level in MS access (if the table is an MS access table and not a SQL table). You can, however, likely do it in the 'After Insert' event of your data entry form.