Nemu

Is ti possible to add more than one record at a time in a table with an .addnew/.update structure???

And if no what should I use to do it??

ANUNEZ

I don't know if I got you right, but yes you can do it. It something like this:

Create a loop to iterate a many times as you or the user one. for example this could be use to pass all the records from one recordset to another:


rstSource.movefirst

do while not rstSource.eof

rstTarget.addnew
rstTarget![ID] = rstSource![ID]
rstTarget.update

rstSource.movenext


loop


You must initialize the recoldsets and close them at the end

I hope this help.

anhmytran

ANUNEZ is partly correct.

No. You cannot "add more than one record at a time in a table with an .addnew/.update structure."
You can use it many times to add more record to the table.

You may use ANUNEZ's approach.
You may use the source as "INSERT INTO YourTable (PrimaryKey and other required fields, separated
by the comman in this parenthesis) VALUES PrimValue, ReqField1Value, ReqField2Value, SoOnValue;"
This source help adding many records to the table without loop.

AnhMy_Tran