Email when new data entered

[dbc1]

I am trying to build a macro to send an email when new data is entered into my db via a data access page. The email part is OK - but how do I generate the message - i.e. how does the db know when new data has been entered?

I would appreciate some help.

 

[hollering]

When I had to do the same task, I just attached my email action to a "Submit" button. But that would only work if you're requiring your user to click submit to change the data.

 

[dbc1]

Thanks - my email is sent as a result of a macro. How do I code the action to the button?

dbc1