Users can "Delete" but not from database

[blyxx86]

I am trying to find a method of allowing users to 'delete' data from the database, but without that information actually being deleted. Is there a possibility of some sort of code or macro that would move the information to a separate table(s) when they click the "Delete Record" button? I know I could execute something similar with a delete command button, but I don't know how to do that with the standard Access toolbar "Delete" ... am I making sense?

If you can cipher out what I'm trying to accomplish and can think of a way to do that, could you please let me know?

Thank you very very much.

[JConsulting]

I am trying to find a method of allowing users to 'delete' data from the database, but without that information actually being deleted. Is there a possibility of some sort of code or macro that would move the information to a separate table(s) when they click the "Delete Record" button? I know I could execute something similar with a delete command button, but I don't know how to do that with the standard Access toolbar "Delete" ... am I making sense?

If you can cipher out what I'm trying to accomplish and can think of a way to do that, could you please let me know?

Thank you very very much.

create a yes/no field in your table.
call it inactive
instead of deleting, you set this field to true
in your recordsource for your form, create a query that filters out inactive
J

[missinglinq]

I've used J's approach before, as well as using a query to append the record to an archive table, then deleting the record from the active table.