Updating RecordSet with values of a second RecordSet
1. I would suggest creating a string variable that will store
"rsPdx.Fields("Title").Value"
then set the original 'title" to this string
I personally normally do not use a ".value" at the end - but that does not
make it incorrect
if your getting errors assigning the rsPdx field to a string then check the
data type of this variable.
you might need to use the str() function to convert this value to a string
ie
Dim strTest as string
strTest = Str(rsPdx.Fields("Title").Value)
bryan
Quote:
> I am trying to update a recordset by giving the corresponding values from
> another open recordset (another connection to a different database on the
> same computer,) here is a typical line:
> rsSql.Fields("Title") = rsPdx.Fields("Title").Value
> I get the following error (translating from French):
> Execution error -2147217887
> An OLE-DB operation in several steps has generated errors.
> However, the following line works:
> rsSql.Fields("Title") = "test"
> Could somebody please help me.
> Thanks,
> Dan Kimhi
