Access Vba Table copy question

[socom36252]

I have a form that looks up an ID in a table. If the ID is there it allows the user to continue the form else i output an error. What im trying to do is if the ID is correct and the operator finishes the form when they click submit i want the fields in the row of the ID chosen to be copied to a new "history table" then deleted from the "current table" Then the "current table" updated with the new ID information. it is important we have a history table to be able to look back and see what changes have been done to these IDs. Again this is in VBA using access.