Print different Page footer subreport by page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am printing a multiple page report and I want to be able to have a
subreport that is linked to the page number. For example, I want to have the
subreport show "tip #2" from TipsTable for page 2 of the publication and "tip
#3" for page 3 etc.

Any ideas?
 
Assuming you have a field in the subreport named TipID that contains the
numbers 1,2,3,... you can use the Link Master and Link Child properties with
Link Master: [Page]
Link Child: [TipID]
 
Hi Duane,

I tried that but when you try to edit the properties for the subreport, it
does not allow you to select a field on the report that contains the field
[Page]

Duane Hookom said:
Assuming you have a field in the subreport named TipID that contains the
numbers 1,2,3,... you can use the Link Master and Link Child properties with
Link Master: [Page]
Link Child: [TipID]

--
Duane Hookom
MS Access MVP
--

Tony C said:
I am printing a multiple page report and I want to be able to have a
subreport that is linked to the page number. For example, I want to have
the
subreport show "tip #2" from TipsTable for page 2 of the publication and
"tip
#3" for page 3 etc.

Any ideas?
Click to expand...
Click to expand...
 
I didn't expect you to "select" anything. Just type the values in the
properties.

--
Duane Hookom
MS Access MVP
--

Tony C said:
Hi Duane,

I tried that but when you try to edit the properties for the subreport, it
does not allow you to select a field on the report that contains the field
[Page]

Duane Hookom said:
Assuming you have a field in the subreport named TipID that contains the
numbers 1,2,3,... you can use the Link Master and Link Child properties
with
Link Master: [Page]
Link Child: [TipID]

--
Duane Hookom
MS Access MVP
--

Tony C said:
I am printing a multiple page report and I want to be able to have a
subreport that is linked to the page number. For example, I want to
have
the
subreport show "tip #2" from TipsTable for page 2 of the publication
and
"tip
#3" for page 3 etc.

Any ideas?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top