Hello,
I have a report that needs to be emailed to specific email addresses for each record as the table is updated.
I have 2 tables, one called tblAuditInfo and one called tblSupplier. I have an input form called frmAuditDataEntry. I also have a report called Receiving Audit.
My goal is to have the user enter data to the form, run an update query to update the supplier name from tblSupplier to tblAuditinfo, then have the form sent via email only for the current record.
I have tried the macro EmailDatabaseObject, but it sends all records. is anyone able to assist with this?
Thanks in advance
Steve
I have a report that needs to be emailed to specific email addresses for each record as the table is updated.
I have 2 tables, one called tblAuditInfo and one called tblSupplier. I have an input form called frmAuditDataEntry. I also have a report called Receiving Audit.
My goal is to have the user enter data to the form, run an update query to update the supplier name from tblSupplier to tblAuditinfo, then have the form sent via email only for the current record.
I have tried the macro EmailDatabaseObject, but it sends all records. is anyone able to assist with this?
Thanks in advance
Steve