Archiving deleted records

[manners]

I don't know if anyone can help but I have created a "delete record" button on my form and I want to be able to store that deleted record so that I can restore it at a later date if required.

Does anybody know of any way this can be done in Access?

 

[Rich]

Simply add a yes/no field, filter records by way of a query or the apply filter method. The criteria for the yes/no field, call it say archive, would be no to view un "deleted" records.
HTH

 

[BukHix]

You could create an archive table and use an append query to add the data to the end of the archive table before it is deleted from the main table. This can be done inside the current database or to another used as a archive depository.

 

[manners]

Thanks, I've created my append query successfully but am not too familiar with VB code so I'm not sure how to attach this to my delete button.

Do you have any ideas please?

 

[manners]

I have now attached the append query to my delete button but it appends all records instead of just the current record that's open. Does anyone know how to specify a specific record to be appended?

 

[BukHix]

In my case I used a checkbox (Yes/No) field. If the field is checked and I hit the delete/append the data will be moved over. I don't have the code anymore or I would post it for you.