deleting a record

[mikeba1]

Hi
I want to keep an audit of deleted records.
I have created another table which has the same structure.
This is currently done with an append query which is run in the on delete event.
This works fine however if the user cancels the delete confirmation the new table still receives the record as does the original table.

Any ideas
Thanks

 

[mikeba1]

Hi again
I have solved the problem by putting a delete query (deleting the record in my copy table) in the after delete confirm if the delete is cancelled.

 

[randy700]

Another method you might want to consider...

Rather than add another table with the same design, simply add 1 more (status) field to the current table. This can be a Yes/No field to indicate if the record has been "deleted" or not.


Randy