Notification in access97

[crispee]

Is there a way to send a notification when a record has been entered in access to a specific person? and if the record is changed to send a notification back to the author?

 

[scking]

Yes, assuming you mean an EMail message for notification, merely write the code for the appropriate event on the form. I generally use the 'Before Update' event to compare the current value of the control with the previous value which is contained in the OldValue property of the control. If the values are different then you can take whatever action you want. Check the FAQ about sending an EMail message in Access.

Steve King Growth follows a healthy professional curiosity