Duplicating Form records

[Guest]

Hello!

I have a formA with a sub form, and the main formA has a field named
PackingNo.
Now I would like to duplicate all records in formA and it sub form several
time, (exp. 5 times) and the number of time to be duplicated is written in a
textbox, then increase the PackingNo field value by 1, on each copy.

Your Helps is really "utopia†for me.

 

[Allen Browne]

If you want to programmatically duplicate the record in the form an in the
subform, you can use code like this:
Duplicate the record in form and subform
at:
http://allenbrowne.com/ser-57.html

If you just need to make 5 labels when the Quantity field reads 5, you can
do it without having to programmatically generate records. Here's how:
Print a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

 

[Guest]

Hi Allen
thanks for your help...but the link has page to display.

My Q is:
I would like to duplicate all records in formA and it sub form several
time, (exp. 5 times) and the number of time to be duplicated is written in a
textbox specified by the user, then code should increase the PackingNo
field value from 1 to the last, on each copy.
exple
like: record1 packingNo = 1
record2 packingno = 2
and....