A2003: Copy record from one recordset to another

[bulrush]

I have 2 recordsets in VBA code, each is based on a different table, but the tables have the exact same layout. One is the main table where data is stored, the other is a temp table used for selecting records then processing them later.

Each table has 50+ fields. How do I use a single command to copy all data from one RS to another without manually typing in rs2!field1=rs1!field1.

Thanks.

p.s. I'm not constructing an SQL statement in VBA to track the records the user wants to process, because I'm afraid the SQL statement might fail if the user selects 600+ records, which is what they will do sometimes.

 

[KenHigg]

I would recommend you add one more field to the main table and store a value that would flag the record for later processing instead of copying all of the data to a secondary table. Hope that makes sense and might be possible...

 

[bulrush]

Thank you.

 

[KenHigg]

Glad to help