How to duplicate records in a subForm? 1)Copy&Paste?? 2)Programmatically??

[Mel]

We have a Form with a subForm

We want to create a subForm Record and then duplicate it "x" times.

1 - How can we just copy and paste the record while looking at the
Form & subForm?

2 - How about code to programmatically duplicate the subForm record
"x" times ?

thanks for any help.

Mel

 

[John W. Vinson]

We have a Form with a subForm

We want to create a subForm Record and then duplicate it "x" times.

Why?

Just store a number field X in the record, and use that in a query to DISPLAY
x copies of the record. What benefit could you possibly get from storing 100
identical records (or records differing only by an autonumber) in your table?


John W. Vinson [MVP]