Hi,
Nice succinct solution Will ;-).
Kid, it doesn't sound like you really want the 2nd table to be the same as the first. If you duplicate the first table into the 2nd, then delete a record from the 1st table - ok - you have the original table.
But, what happens when you delete a record from the 1st table again - next day?
You copy the 1st table to the 2nd, then delete the record from the first - right? You've lost the change that you made on the previous day.
Firstly, copy your first table to a new table name (call it tblDeletedRecords) without any data.
Then, before you delete the record from table1, use an APPEND query (as Will has suggested) to append this record to table 2.
Delete the record from table1.
Regards,
Darrylle
Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk