copy block of data from table to table?

[xq]

i'm doing a userform which is in a datasheet form, that allow user to in put data as much as they can and save into table1, after they click the bottun OK, then i'll copy all those block of data to table2, all i can do is select each in each field and each record from table1 and insert into table2, is there any other better way of doing these?
thanks million for any help!

 

[Petemush]

Use an Append Query. Set it up to select all data from table1 and append it to table2.Start a new query in design view and select the Query menu, select append query and it's all self explanatory from there

Cheers,

Pete

 

[xq]

thanx, but i would like it's done in the code, user only have to input data and click button OK, all the data is copied automatically into table2. sorry i didn't say that clearly.

 

[Petemush]

So put:

DoCmd.OpenQuery "YourAppendQuery"

in the on click event of the ok button. If you REALLY REALLY want no trace of a query then use a DoCmd.runSQL with a SELECT...INTO statement.

Cheers,

Pete

 

[xq]

i got it! thanks a lot!