Copy entire record between recordsets

[GeoMetry]

Is there a way to copy an entire record from one recordset to another? I currently loop thru all the fields and it seems inefficient. I would like to do something like:

rs.fields = rt.fields

instead of:

while intCounter < rs.fields.count
rs.fields(intCounter) = rt.fields(intCounter)
intCounter = intCounter + 1
wend

 

[Dennisk]

thats the way Access works. Why should it be inefficient?

 

[MStef]

Try to do this with APPEND QUERY.