I am writing my own synchronization program to work with our company database. There are a few things that I needed to do that replication didn't work right with. Anyways I was wondering if anyone knew if there was any way to copy one whole recordset at a time without setting all the fields. I mean instead of saying:

myrecs.addnew
myrecs!field1 = myotherrecs!field1
myrecs!field2 = myotherrecs!field2
myrecs!field3 = myotherrecs!field3

I would like to say something like

myrecs.addnew
myrecs = myotherrecs

I don't know there might not be a way to do that, but I thought that I would try anyway. thanks.

What's wrong with just copying the table?

I don't want to copy the whole thing, but I would like to append one whole recordset to another one. I know that I can do this through an append query but I would like to do it totally from code. Anyhelp would be appreciated. thanks