Using Recordset rst.AddNew

[dandoescode]

So recordsets appear to be a very powerful tool in access. I'm interested to know if it is possible when using the recordset AddNew command, to insert a field value from another open recordset.



Basically, would a line of code like

rstDataOutputFinal.AddNew
   rstDataOutputFinal![TableName1] = rstDataOutPut!TableName1
rstDataOutputFinal.Update

update my DataOutputFinal table, with a value from my table DataOutPut? DataOutPut and DataOutputFinal would have already been opened and moved to the desired records.

[John_G]

Hi -

There is no problem with that - your code looks fine. You can also use rst.Edit - rst.Update if the record in rstDataOutputFinal already exists and you have moved to it.

John