Re: Report Subreport References 2000 2003

Thank-you that works. I appreciate your help.


"Duane Hookom" wrote:

> Try:
> =SingleDailyreport.Report!SingleDailyProductionreport.Report!yield
>
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "eb1mom" <eb1mom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:6D6A4D61-A323-4F02-B2D3-891457800C90@xxxxxxxxxxxxxxxx
> >I am using as control source in textbox on Main report. Main Report name is
> > MainDailyReport. SingleDailyReport is a subreport on MainDailyreport and
> > singledailyproductionreport is a subreport on SingleDailyreport. Yield is
> > a
> > calculated field on singledailyproductionreport. Boss wants yield figure
> > displayed in upper right corner of main report not on
> > singledailyproductionreport. And for a couple years it worked fine. Then
> > he
> > upgraded to 2003.
> >
> > "Duane Hookom" wrote:
> >
> >> Where are you using this expression? Is it the control source in one of
> >> the
> >> reports?
> >>
> >> What are the names of your reports and subreport controls?
> >>
> >> --
> >> Duane Hookom
> >> MS Access MVP
> >>
> >>
> >> "eb1mom" <eb1mom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:0352053D-F903-47AB-8DF0-D0CD38DCE1CF@xxxxxxxxxxxxxxxx
> >> > With help from here I was able to get form subform problems worked out.
> >> > However my report subreport references that work in 2000 and do not
> >> > work
> >> > in
> >> > 2003 are still causing me problems. Here is what I have
> >> >
> >> > =Reports!MainDailyreport!SingleDailyreport!SingleDailyProductionreport.Report!yield
> >> >
> >> >
> >> > Works in 2000 but get error Name? in 2003. Any suggestions would be
> >> > appreciated.
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Adding a ck mark?
    ... Duane Hookom ... MS Access MVP ... The fields used in the Detail part of the Report are: ... It's difficult to trouble shoot when one control source in the detail ...
    (microsoft.public.access.reports)
  • Re: Adding a ck mark?
    ... exact expressions you use in your report controls. ... Duane Hookom ... MS Access MVP ... It's difficult to trouble shoot when one control source in the detail ...
    (microsoft.public.access.reports)
  • Re: Adding a ck mark?
    ... Duane Hookom ... MS Access MVP ... Let's start a new report. ... and the control source in the report footer is: ...
    (microsoft.public.access.reports)
  • RE: Expressions that Return "#Num!"
    ... the control source was [disability income]. ... "Duane Hookom" wrote: ... Text 201 reference is a calculation on the report where the ...
    (microsoft.public.access.reports)
  • RE: Calculations
    ... "Duane Hookom" wrote: ... You would need your code to set the control source of the sum text box ... I much prefer creating a report record source with always known ... I need the totals based on each of these three choices, BUT, ...
    (microsoft.public.access.reports)