Trouble with subreports

  • Thread starter Thread starter GitarJake
  • Start date Start date
G

GitarJake

Can someone please remind me how to do this?!

I have a mainform with a subform. On the subform I have a calculated
control; text41. On the mainform, I have a control that I'd like to display
the value of subform.text41. I've tried the 2 examples below among others
but always get '#Name?'.

=[Reports]![rptMonthlyForcast]![MonthlyForcastSecondary].[Report]![text41].[Value]

=me!MonthlyForcastSecondary.Report!text41

What am I doing wrong?

TIA

Jake
 
you're talking about having a main *form* and a sub*form*, but your
reference says [Reports]

what objects are you actually working with - form/subform or
report/subreport?
 
Sorry, see how confused I am?

Reports!

Where you see forms think Reports! :)

Jake


tina said:
you're talking about having a main *form* and a sub*form*, but your
reference says [Reports]

what objects are you actually working with - form/subform or
report/subreport?


GitarJake said:
Can someone please remind me how to do this?!

I have a mainform with a subform. On the subform I have a calculated
control; text41. On the mainform, I have a control that I'd like to display
the value of subform.text41. I've tried the 2 examples below among
others
but always get '#Name?'.

=[Reports]![rptMonthlyForcast]![MonthlyForcastSecondary].[Report]![text41].[
Value]

=me!MonthlyForcastSecondary.Report!text41

What am I doing wrong?

TIA

Jake
Click to expand...
Click to expand...
 
well, i tested a report/subreport that worked with the following syntax

=[Reports]![rptMain]![Child1].[Report]![Text0]

the only thing i can suggest is to make sure you're using the name of the
subreport *control* in the expression, which may be different from the name
of the subreport report object in the database window. example - in my test,
the name of my subreport is rptSub, but the name of the subreport *control*
in my main report is Child1. to make sure you get the correct name: open
the main report in design view. click once on the subreport within the main
report, to select it. in the Properties box, click on the Other tab, and
look at the Name property. that's the name of the subreport control.

hth


GitarJake said:
Sorry, see how confused I am?

Reports!

Where you see forms think Reports! :)

Jake


tina said:
you're talking about having a main *form* and a sub*form*, but your
reference says [Reports]

what objects are you actually working with - form/subform or
report/subreport?


GitarJake said:
Can someone please remind me how to do this?!

I have a mainform with a subform. On the subform I have a calculated
control; text41. On the mainform, I have a control that I'd like to display
the value of subform.text41. I've tried the 2 examples below among
others
but always get '#Name?'.
Click to expand...
=[Reports]![rptMonthlyForcast]![MonthlyForcastSecondary].[Report]![text41].[
Value]
=me!MonthlyForcastSecondary.Report!text41

What am I doing wrong?

TIA

Jake
Click to expand...
Click to expand...
Click to expand...
 
Thank you Tina,

I think I had the child name wrong.

I double checked with your ewxample and it works.

Thanks again,

Jake


tina said:
well, i tested a report/subreport that worked with the following syntax

=[Reports]![rptMain]![Child1].[Report]![Text0]

the only thing i can suggest is to make sure you're using the name of the
subreport *control* in the expression, which may be different from the
name
of the subreport report object in the database window. example - in my
test,
the name of my subreport is rptSub, but the name of the subreport
*control*
in my main report is Child1. to make sure you get the correct name: open
the main report in design view. click once on the subreport within the
main
report, to select it. in the Properties box, click on the Other tab, and
look at the Name property. that's the name of the subreport control.

hth


GitarJake said:
Sorry, see how confused I am?

Reports!

Where you see forms think Reports! :)

Jake


tina said:
you're talking about having a main *form* and a sub*form*, but your
reference says [Reports]

what objects are you actually working with - form/subform or
report/subreport?


Can someone please remind me how to do this?!

I have a mainform with a subform. On the subform I have a calculated
control; text41. On the mainform, I have a control that I'd like to
display
the value of subform.text41. I've tried the 2 examples below among
others
but always get '#Name?'.


=[Reports]![rptMonthlyForcast]![MonthlyForcastSecondary].[Report]![text41].[
Value]

=me!MonthlyForcastSecondary.Report!text41

What am I doing wrong?

TIA

Jake
Click to expand...
Click to expand...
Click to expand...
 
you're welcome, Jake, glad that fixed it! :)


GitarJake said:
Thank you Tina,

I think I had the child name wrong.

I double checked with your ewxample and it works.

Thanks again,

Jake


tina said:
well, i tested a report/subreport that worked with the following syntax

=[Reports]![rptMain]![Child1].[Report]![Text0]

the only thing i can suggest is to make sure you're using the name of the
subreport *control* in the expression, which may be different from the
name
of the subreport report object in the database window. example - in my
test,
the name of my subreport is rptSub, but the name of the subreport
*control*
in my main report is Child1. to make sure you get the correct name: open
the main report in design view. click once on the subreport within the
main
report, to select it. in the Properties box, click on the Other tab, and
look at the Name property. that's the name of the subreport control.

hth


GitarJake said:
Sorry, see how confused I am?

Reports!

Where you see forms think Reports! :)

Jake


you're talking about having a main *form* and a sub*form*, but your
reference says [Reports]

what objects are you actually working with - form/subform or
report/subreport?


Can someone please remind me how to do this?!

I have a mainform with a subform. On the subform I have a calculated
control; text41. On the mainform, I have a control that I'd like to
display
the value of subform.text41. I've tried the 2 examples below among
others
but always get '#Name?'.
Click to expand...
=[Reports]![rptMonthlyForcast]![MonthlyForcastSecondary].[Report]![text41].[
Value]

=me!MonthlyForcastSecondary.Report!text41

What am I doing wrong?

TIA

Jake
Click to expand...
Click to expand...
Click to expand...
 
Back
Top