Duplicate a record in a form including subform data

[KWasley]

Hi,



I'm looking for a method to copy field data from a record in a form which includes information in a subform. I need to do this in order to allow the user to copy data from one record and then edit it lightly rather than filling in the same information over and over.

I have searched the web to try and find an answer however I am finding it difficult to implement the coding given into my form. My subform has a primary key which is an ID (autonumber) and a foreign key which is the ID of the main form. Along with these two, there are six fields which allow multiple items to be entered displayed in the form as list boxes.

Any help would be appreciated, thanks in advance.
Kyle.

[rpeare]

So, this is something like a purchase order where your purchase order is for a specific customer and they order almost the same thing every time so you want to copy not only the main information on the PO but all the detail lines as well? Or do you want to selectively copy items from the subform?

What you would likely have to do is going to involve VB script (not macros)

The first think you'll have to do is insert a record into your 'main' table with the same information as the current record, then find the PK for that new record. Once you have that you will have to systematically insert records into your 'sub' table with the PK you just generated from the new main record. If you're using autonumbers as your PK on both tables I'd just caution you to make sure you don't have too many concurrent users to avoid any possible mishaps with PK/FK matches.