If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trouble with subreports
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 |
#2
|
|||
|
|||
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" wrote in message news:Uv1Vd.5241$2s.2653@lakeread06... 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 |
#3
|
|||
|
|||
Sorry, see how confused I am?
Reports! Where you see forms think Reports! Jake "tina" wrote in message ... 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" wrote in message news:Uv1Vd.5241$2s.2653@lakeread06... 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 |
#4
|
|||
|
|||
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" wrote in message news:At2Vd.5354$2s.2164@lakeread06... Sorry, see how confused I am? Reports! Where you see forms think Reports! Jake "tina" wrote in message ... 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" wrote in message news:Uv1Vd.5241$2s.2653@lakeread06... 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 |
#5
|
|||
|
|||
Thank you Tina,
I think I had the child name wrong. I double checked with your ewxample and it works. Thanks again, Jake "tina" wrote in message ... 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" wrote in message news:At2Vd.5354$2s.2164@lakeread06... Sorry, see how confused I am? Reports! Where you see forms think Reports! Jake "tina" wrote in message ... 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" wrote in message news:Uv1Vd.5241$2s.2653@lakeread06... 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 |
#6
|
|||
|
|||
you're welcome, Jake, glad that fixed it!
"GitarJake" wrote in message news:%DkVd.5606$2s.1421@lakeread06... Thank you Tina, I think I had the child name wrong. I double checked with your ewxample and it works. Thanks again, Jake "tina" wrote in message ... 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" wrote in message news:At2Vd.5354$2s.2164@lakeread06... Sorry, see how confused I am? Reports! Where you see forms think Reports! Jake "tina" wrote in message ... 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" wrote in message news:Uv1Vd.5241$2s.2653@lakeread06... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Referencing individual rows in subreports | BECAM | Setting Up & Running Reports | 0 | February 2nd, 2005 12:25 AM |
header of main report and detail (subreports) splitting | jenn | Setting Up & Running Reports | 0 | December 30th, 2004 04:40 PM |
Opening Subreports with dates | Don Sealer | Using Forms | 1 | December 28th, 2004 02:19 AM |
Referencing Properties of Nested Subreports | Dan | Setting Up & Running Reports | 1 | October 13th, 2004 06:04 PM |
Repost-Still Suffering with Subreports | IreneJ | Setting Up & Running Reports | 9 | August 31st, 2004 04:55 AM |