Printing multiple copies based on data value

[RideGuy]

I have an Access 2000 db which processes permit orders, and prints the permits. A permit order can consist of more than one type of permit, as well as more than 1 copy of each type. For example, one order might have 3 AH permits and 2 WH permits, for a total of 5 permits.

I have a tables for customers (tblCust), orders (tblPermitOrders), and order details (tblPermitDetails). I have a main form which contains the customer info (frmCust). It has a subform which contains the order info (sfrmPermitOrder), including the total quantity of permits in the order (TotQty). This subform has a subform (sfrmPermitDetail) which contains the amount (Qty) and the details for each group of permits in the order.

I need a button on sfrmPermitOrder which opens a report which is the actual permits. Each permit needs to print a on different page and contains details about the permit.

I'm stuck on how to use the values entered in sfrmPermitDetail.Qty and sfrmPermitOrder.TotQty to determine the number of the permits to print. For example, if one record in sfrmPermitDetail has 3 AH permits, and a 2nd record has 2 WH permits, when I print the permit order, it needs to print 5 pages, 3 pages for AH permits and 2 pages for WH permits.

I'd appreciate any help anyone can provide! Thanks!

 

[dhookom]

Consider using the "Better Solution" on Allen Browne's web page.

Duane
Hook'D on Access
MS Access MVP

 

[RideGuy]

Thank you Duane,

That was the approach I needed!