Record Cloning complete procedure
Posted on 2006-06-07
I reviewed many of the questions/solutions about record cloning; however, i get lost because the answers are fragmented with extra questions within the main question. Is there a SUMMARY of the Record cloning code and which "ON XYZ" line to place it ?
I would like to be on a Main Form record which uses FormulaID as a primary key. this field is input and not autonumber unless you tell me to make it autonumber for the clone.
there is a subform which shows RAWID records; typically about 10 subform raw material records showing the amount of pounds per rawid. Pretty much a bill of materials form.
FormulaID and RawID are text fields.
So how can i take an existing record, hit a command button, and duplicate the entire record except the need to either input a NEW FormulaID or have FormulaID as an autonumber. I prefer inputting a new formulaID but i can go either way.