[AccessD] Coding for backing up deletes

Do you really have to move it to another table? You could just add a field
-- Active/Inactive -- something like that. You'll have to remember to update
all your queries, etc., but unless there's some reason to really need to
move it to another table, I don't think I'd bother. 

Susan H. 

Any of our craftsfolk ever coded for something like this please?

The user wants to delete a file in a table. She goes to a form, and finds
the record. She clicks a button and the record is 'deleted' - only really it
goes into a waiting backup table ... just in case. 

Expert guidance would be appreciated.