Printed confirmation of deletion

[Terrier]

It's me again.

I've got a problem when I delete an item off a table. I need to print out a report with the details of the item deleted so it can be sent off elsewhere as a manual record.

I've used the 'delete record' from the wizard and thought that I could just tack a macro on to it as well but it doesn't seem that easy.

Any ideas?

 

[smedvid]

Sounds like u need a transaction log to record deletes. In the past, I've made logical deletions only on a table by setting a flag in that table to "DEL". I would also have data field of the last update. Then I suppress all 'DEL' records from the data entry forms and reports. You can then write a report with just the DEL records. htwh, Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...