Duplicating Multiple Records

[ChuckW]

Hello,

I have a Form and a subform. The form name contains two text boxes which
include Company Name and Protocol Name. The subform is a continuous form
that allows a user to select various items. Reports are then generated which
list the Company Name and Protocol in the report header and the items
selected in the detail section. There can sometimes be 10 or so items per
protocol. The person using this application says that they will often create
a new record in the main form and enter a new Company Name and Protocol but
the list of items is exactly the same as a previous protocol t hat already
exists. What I want to do is to somehow keep all of them items from a
previous protocol but create a new overall record with blank text boxes where
I can plug in a new company name and protocol rather than creating a brand
new overall record from scratch. Basically I am trying to save the person
time in having to reenter the same item numbers for a new protocol. I was
testing out the duplicate records icon but it will only duplicate one record
rather than all records in my subform. Is there a way to duplicate all
records in my subform?

Thanks,

 

[ManningFan]

Try building a new table with all the item numbers for a given
Protocol/Company, and have a field called "Template". Fill the field
with "Similar to Company X" or whatever. Then have a dropdown that
reads the available template names and grabs the item numbers based on
the template chosen.