Duplicating Form records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vorlon - 05 Oct 2007 10:36 GMT

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.

Reply to this Message

Allen Browne - 05 Oct 2007 11:47 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I have a formA with a sub form, and the main formA has a field named
> PackingNo.
[quoted text clipped - 4 lines]
>
> Your Helps is really "utopia” for me.

Reply to this Message

Vorlon - 05 Oct 2007 12:52 GMT

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....

> If you want to programmatically duplicate the record in the form an in the
> subform, you can use code like this:
[quoted text clipped - 16 lines]
> >
> > Your Helps is really "utopia” for me.

Reply to this Message