[robtech]

I have created a "Master Table" and forms that can update the master table. Everytime there is a change made through the forms I have it set to go to an audit table.

I want to have an email generated to me where I can view the changes and approve/deny them before they update the master table.

Thank you in advance for your help!

[Vold]

application.docmd.RunSQL strErrorLog

If gblnEmailOn Then
application.docmd.OutputTo acOutputReport, "rptErrorLog", acMyFormat, rptErrorLog.snp", True
application.docmd.SendObject acSendReport, "rptErrorLog", acMyFormat, (E-Mail Removed), , , "ErrorLog", , False
End If

'Use the Object Browser by queries.
'Rgds Vold