record clone problem

[nycepete101]

Hello all
I have a form with three fields. Name,oderid, Order. Now each person can have multiple orderids. I want to be able to clone my recordset so the user dosent have to rekey the fields.? i know in access their is a duplicate record control..

So basically it will clone the recordset so the user dosent have to rekey all the information, becuase i will be adding more feilds...?


Example would really help

thanks
newbee

[si_the_geek]

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?