I have two tables with the exact same structure, one table has customer info. in it and the other one is empty. What I have done is created a recordset to hold info from the customer table based on search material supplied by the client. I now want to be able to fill in all the selected records to the temp table but would like to do it without having to list every field in an Insert Into statement because there are like 50 fields.
Can I some how make a statement like "Insert Into tempTable * objrs" because I'm going to be filling in every field.

This would be so much more easier, and I'm sure its possible, but I can't figure it out.

Thanks...