\r\n\r\n \r\n \r\n \r\n # 2 \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n  \r\n \r\n 06-04-2001, 08:31 AM\r\n \r\n \r\n \r\n \r\n | \r\n
\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n | \r\n\r\n \r\n\r\n Guest \r\n \r\n \r\n\r\n | \r\n | \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n Posts: n/a\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n | \r\n \r\n \r\n \r\n | \r\n
\r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n\r\n \r\n \r\n \r\n  \r\n Re: Adding new records...\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n | \r\n \r\n\r\n \r\n\r\n\r\n I don\'t know if I got you right, but yes you can do it. It something like this: \r\n \r\nCreate a loop to iterate a many times as you or the user one. for example this could be use to pass all the records from one recordset to another: \r\n \r\n \r\nrstSource.movefirst \r\n \r\ndo while not rstSource.eof \r\n \r\n rstTarget.addnew \r\n rstTarget![ID] = rstSource![ID] \r\n rstTarget.update \r\n \r\n rstSource.movenext \r\n \r\n \r\nloop \r\n \r\n \r\nYou must initialize the recoldsets and close them at the end \r\n \r\nI hope this help. \n \n \r\n \r\n\r\n | \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n  \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n\r\n | \r\n
\r\n