Custom Shipping Labels

[Hank44]

I have a report (Shipping Labels:
This report is not bound to a query or a table but is presently populated from a loaded form (Shipments) wher it gets its data from. Here is what I need to do. I need to be able to show the PartOfTotalPieces on individual labels to the Total # Number of Pieces. So if I have 3 total pieces then I would have 3 labels each with 1 of 3, 2of 3 and finally 3 of 3.

How do I get there from here

 

[Simon_MT]

I cheated by having an unbound table with numbering 1 to [MaxNo] unbound in the Report's query and selected <=3.

Simon

 

[Hank44]

I have a report (Shipping Labels:
This report is not bound to a query or a table but is presently populated from a loaded form (Shipments)

Okay, so how did you do this?

Since I dont have a query for the form?

Help me out a bit please?

 

[Simon_MT]

Where is the information on the Form stored?

Simon

 

[SpentGeezer]

Just use this sample from the Spent Geezers Association.....

EDIT - You will have to create tbl_Label for this method to work, and bind it to the report. The table is populated each time a label is created (1 row for each part).

 

[Hank44]

Hey,

I want to thank you so much!!! I struggled with this thing for quite a while and you provided the perfect answer. I OWE YOU!!!

THANK YOU