save from query1 to table2

[adriany]

looking for source code on save button i can use

like to save all data i have from query1 to table2
when i press save button.

can i use update query or this their easier way?

 

[John Vinson]

looking for source code on save button i can use

like to save all data i have from query1 to table2
when i press save button.

can i use update query or this their easier way?

Could you explain just what you want?

If you change Query1 into an APPEND query, appending to Table2, and
run it - it will add new records to Table2 containing the data in
query1. Is this what you want to have happen?