how to copy a record to another table

[kitaeshi]

Hi i new to access and i hope somebody here can guide me how to create this using VBA.

i have a table which have employee records. I need to create a form tat when i click the button, it will move the record to another table and also remove the record from the current table. any idea?

Tks for reading.

 

[GaryPanic]

check the samples on this one
someone asked this a couple of weeks ago..
(I think the answer was apepnd qry and delete qry)