Copying data from one table to another table

[cctrinh]

Hi,

Can some show me how to write the codes to copy the data from one table to another. When I click on a button I want to copy the data from table1 to table2. Please help....

Thank you,

 

[LonnieJohnson]

I'm not sure if you are wanting to copy records or select records. At any rate, you would want to use an append query that will grab the records from table1 and append them to table2.
Then in your button's click event, use the code

Docmd.OpenQuery "NameOfTheAppendQuery"

Hope this helps, ljprodev@yahoo.com
Professional Development
MS Access Applications