It's still not clear to me what you need. You have not provided any code for analysis.
What would you like different on the labels? The image shows 400 Qty on each label. What should each say?
There is likely more than one way to accomplish what you want.
I have a procedure to batch print variable number of labels for multiple records. Printing is to sheet labels on a normal printer. Code writes records to a 'temp' table.
Consider:
Code:
Sub PrintLabels()
Dim y, z, t, q, v
t = 100 'total quantity units
y = 12 'units per box
z = Int(t / y) + IIf(t Mod y > 0, 1, 0)
For v = 1 To z
q = IIf(v < z, Int(t / y), t Mod y)
Debug.Print "Qty: " & q & ", Vol: " & v & " of " & z
Next
End Sub
Reference controls on form for the t and y inputs.
Instead of Debug.Print to immediate window, save record to table.