A
aft3rgl0w
I have a report set up for printing address labels. However, since we use
the labels sporadically, I need a way to be able to print address info to
certain labels on different print jobs. The label sheet is 8.5x11, the
labels are 4"x2", 2 across, 5 down. To try this I have a main report
(AddMain) set up with 10 subreports which all use the same report (AddSub)
for their source. I also have a table with fields for the address info along
with a LabelNum field which indicates which label numer it should print on.
Labels numbers start at 1 at the top left and progress across then down the
page. With forms set up this same way, I can use the same subform and filter
it on the main form based on labelNum, but in the reports I can't do this
because it won't let you set the source in preview mode. SO. I'm think i
either have to use a global variable of some description, or a function.
However, it needs to be able to capture the labelNum somehow, and I can;t
figure this out. Is there any way to reference the parent CONTROL name? ALl
the subreports are named as AddLabelX where is is the label number. Or if
there's a different, easier way to do this, please help!!
the labels sporadically, I need a way to be able to print address info to
certain labels on different print jobs. The label sheet is 8.5x11, the
labels are 4"x2", 2 across, 5 down. To try this I have a main report
(AddMain) set up with 10 subreports which all use the same report (AddSub)
for their source. I also have a table with fields for the address info along
with a LabelNum field which indicates which label numer it should print on.
Labels numbers start at 1 at the top left and progress across then down the
page. With forms set up this same way, I can use the same subform and filter
it on the main form based on labelNum, but in the reports I can't do this
because it won't let you set the source in preview mode. SO. I'm think i
either have to use a global variable of some description, or a function.
However, it needs to be able to capture the labelNum somehow, and I can;t
figure this out. Is there any way to reference the parent CONTROL name? ALl
the subreports are named as AddLabelX where is is the label number. Or if
there's a different, easier way to do this, please help!!