G
Guest
Hi All, could you please let me know if the following is possible. I have a
form linked to a table and I'm also using Allan Brownes audit log program.
On the form I can add new incoming records, new outgoing records and also
edit these. What I would like to achieve is to delete a record. On the form
the user has to enter the department requesting the delete, the date, the
person requesting the delete and the reason for the deletion. I would a
button that checks all the required fields have been completed, then deletes
the records (this places a record in my audGenReg (audit log table)), then to
print the control report with all relevant data, send the control report as
an attachment to outlook ready to email, then once send has been done close
outlook and the report. I have managed to achieve this for incoming and
outgoing new records and for edited records but cannot get it to work for
deleted records. I would appreciate it if someone could let me know the
sequence of events I should use as I'm unsure how to capture the register
number of the deleted record to print & email. Many many thanks Sue
form linked to a table and I'm also using Allan Brownes audit log program.
On the form I can add new incoming records, new outgoing records and also
edit these. What I would like to achieve is to delete a record. On the form
the user has to enter the department requesting the delete, the date, the
person requesting the delete and the reason for the deletion. I would a
button that checks all the required fields have been completed, then deletes
the records (this places a record in my audGenReg (audit log table)), then to
print the control report with all relevant data, send the control report as
an attachment to outlook ready to email, then once send has been done close
outlook and the report. I have managed to achieve this for incoming and
outgoing new records and for edited records but cannot get it to work for
deleted records. I would appreciate it if someone could let me know the
sequence of events I should use as I'm unsure how to capture the register
number of the deleted record to print & email. Many many thanks Sue