Move record from one table to another

Hi, I am making a database that involves three different tables, I’ll call them PRIMARY, RETURNED and MISSING. Right now I have it set up so that a combo box will search the PRIMARY table based upon last name and then show the ID, lastname, and firstname of the person on the form. I need to make a couple of buttons or something that will take the entire record from the PRIMARY table and move it to the RETURNED or MISSING table depending on which button is pressed. I want the data to be moved, not copied so that it will no longer exist in the PRIMARY table, only in the MISSING or RETURNED table that it got moved to. I just started working with MS Access and I don’t know any VBA, so please excuse my ignorance. Thanks for any help you can give me.