Print Multiple Reports in a Certain order?

[chaddiesel]

Hello,

I have a form which contains the shipment destination information and the ship date of our company shipments. I have a subform set up which contains all the boxes in that shipment.

I have a "Print Labels" button on the subform that sends the appropriate box information on the subform to a report called "Labels." This is how we are going to print our shipping labels. I also have a label which is a report called "Destination_Label" that contains the address where the shipment is to be delivered. While each box label in the "Label" report is unique, the destination label is the same for all the boxes in that shipment.

What I would like to do is print 2 copies of the box label and 1 copy of the destination label in that order. For example, if I have 3 boxes on my subform, I would like press a button that would cause the labels to print like this:

Box Label 1, Box Label 1, Destination Label, Box Label 2, Box Label 2, Destination Label, Box Label 3, Box Label 3, Destination Label

We print a lot of labels and it would be easier to apply the labels in order instead of dealing with 2 stacks of labels. Again, each box label is unique, but the destination label is the same for the entire shipment.

Is something like this possible? Help would be greatly appreciated.

Thanks,

Chad

 

[RichO]

What I have done for a similar situation is to use VBA and SQL to create a temporary table that the labels are printed from. That way I can control the order and layout of the labels.

What is your label layout (how many across / down?)

 

[chaddiesel]

Hello,

Thanks for responding, here is a picture of my labels:

http://www.chadworld.com/images/labels.jpg

and here is a picture of my form:

http://www.chadworld.com/images/form.jpg

I should have mentioned that there are only 4 locations (right now) that we ship, so in the form, if you select San Diego as the destination, I have query that feeds the destination label report. I'm new to access and don't know a lot about programming visual basic. Any help would be appreciated.

Thanks,

Chad

 

[RichO]

Because the 2 labels use different layouts and the number of fields don't match it gets a little more complicated, but still, anything can be accomplished.

How many of these labels fit on a full page of label stock? I'm assuming the label on the right uses the same size label as the one on the left?