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
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com