Hi nycepete101, welcome to VBForums!


Ideally you shouldn't be storing duplicate data like that (the persons data should be in a different database table), but I'm guessing that you either haven't learnt that yet, or you have a reason for this method.

I think that cloning the recordset isn't what you want to do (it has a different meaning), you just want to copy some of the fields from one record to the next. If this is the case, quite how you should do it depends on how you are showing/editing the data. Can you post an explanation and some code?