We produce 4 different label layouts: Name and address, name only, and two different fixed content graphics. We print on sheets of three columns by 8 rows of labels. Frequently when we produce either name and address or name only labels, we immediately follow that by producing the same number of one or both of the graphics labels. What I would like to be able to do is roughly this:-
1. Before printing the text labels, get the user to specify which graphics labels are required (if any) - this is easy enogh to do.
2. Print the text labels
3. If a graphics label has been selected then output them starting at the next unoccupied row on the current page. (I know how to move to the next row)
I guess my code needs to recognise that it has just dealt with the last text label before it allows Access to move past the last entry and close the report.