You need to copy field-by-field.

I assume that the RecordNum position is already existing snd that both recordsets contain the same columns in the same order.

for i = 0 to adoSiteRS.fields.count - 1
adolog(i) = adoSiteRS(i)
next i

>What ado command will move one recorset(adoSiteRS("RecordNum") to the same position in another recordset (adoLog("RecordNum")?
>
>
>I tried adoSiteRS.Move (adoLog("RecordNum")
>
>but that just moves it x number of times from where it currently is