I want to create some code that will delete printers from my printers table and automatically move them to a deleted table. I want to have this code do everything automatically. I am going to create a form that will ask what printer I want to delete, and when I type the name of the printer, all of the information that goes along with that printer will move into a table called tblDeletedPrinters. We need to do this so that when we delete one of our printers, we can have the information in a table in case we need to run queries on the data. Can someone help me with this?

Chad,
I have a suggestion. Why not instead of deleting those records with
a field DELETED checked, just create a new query that will filter
without this record. Like a query named qryActivePrinters.
The advantage is less maintenance.
John