Move specific record to another table Access 2003
Posted on 2008-06-24
I like to move a complete specific selected record in a form to table for archiving.
original table is called tbl_hw and archiving table is called tbl_hw_archive.
Both tbl_hw and tbl_hw_archive have the same filds.
How can I select on record and add this record including all filds to the other table and after this is done delete this record in the original table.