Deleted Records

[mugman17]

Instead of actually deleting a record, I would like to have a button that takes the record mentioned (based on DealID) moved to another table which keeps track of Deleted Records. Do I need to run an append query. How do I get only the one recorded appended and not the whole table.

Thanks

 

[llkhoutx]

By setting appropriate criteria in the append query.