Aaron,
You'll probably need to give us a bunch more info to get a more specific answer, but here's how I'd approach this.
I would avoid using a temporary table or records that get added and deleted, though that may be what some others suggest. Temp tables and records lead to bloating of your mdb file and are a PITA.
I would write code to determine the total number of stickers to be printed and then loop through that many times. It might look something like this:
Sub btnPrintSkidLabels_Click()
Dim intTotal As Integer
Dim intThisOne As Integer
'This is where you'll determine how many labels to print
'The number 5 below will be replaced with the product of
'those calculations.
intTotal = 5
intThisOne = 1
Me!txtTotal = intTotal
Do Until intThisOne = intTotal
Me!txtThisOne = intThisOne
Call DoCmd.RunCommand(acCmdPrint)
intThisOne = intThisOne + 1
Loop
End Sub
If you need help determining the numbers for the Total and ThisOne, post back with information about what determines this. If it's stored in a table or on the form, be very specific about the names of all the objects involved and any table relationships inovolved. If it's based on some standard equation, include that.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Affordable Development, Professionally Done
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.