Copy record from Recordset1 to Recordset2?

[aliendan]

OK, I'm brain-dead here...how would I copy a record from a recordset to another recordset? Can someone help me?
Dan Rogotzke
Dan_Rogotzke@oxy.com

 

[braindead2]

use an append query.

 

[mymou]

Aliendan


If you ae talking ADO etc I guess you are talking about cloning.

Never used it - but "the Clone method create copies of a Recordset and then lets the user position the record pointer of each copy independently".

arstStores(1).Open strSQL, strCnn, , , adCmdText
Set arstStores(2) = arstStores(1).Clone

If you could tell me why you need to do it - i would be quite interested.

Stew

 

[aliendan]

mymou,

Please read my post from yesterday called "Recordset to Querydef". Then answer I got will work but I'm having a problem doing it. Let me know what you think, ok?
Dan Rogotzke
Dan_Rogotzke@oxy.com