Erro #Name?

[Ray67]

Hello

I'm getting this error in reports.
I put this code
=[R_Fee Settlement BalanceTotal].[Report].[Fee Settlement Balance]+[R_Fee Settlement BalanceTotal].[Report].[Refunds]+[R_Fee Settlement BalanceTotal].[Report].[Medical Assoc Transfer]+[R_Fee Settlement BalanceTotal].[Report].[Returned Checks]+[R_OutstandingPaymentsGrandtotal].[Report].[SumOfAmount] in a text box and that's when i get the error.



Once i take off this part [R_OutstandingPaymentsGrandtotal].[Report].[SumOfAmount] it works fine. I checked to see if the name is spelled right and it is. Not sure what i'm doing wrong.

Thank you

[RuralGuy]

If these are all controls on your Report then just use this syntax: Me.[Fee Settlement Balance]+Me.[...

[June7]

Me qualifier doesn't work in ControlSource.

R_OutstandingPaymentsGrandtotal is a subreport on main report R_Fee Settlement BalanceTotal?

Pulling values from subreport can be tricky. Give the subreport a name different from the object it holds, like ctrGrand and the SumOfAmount textbox a name like tbxSum. Then in the expression try:

+ Reports![R_FeeSettlement BalanceTotal]!ctrGrand.Report.tbxSum

[Ray67]

Thank you for your reply. It's still giving me the same error.

[RuralGuy]

Is June7 correct and you are trying to reference controls on a SubReport?

[Ray67]

Yes June7 is correct. I'm trying to get totals on the main report from multiple sub reports.

[RuralGuy]

The syntax is SubReportControlName.REPORT.ControlName. Is that what you are using?

[Ray67]

no i try what June7 told me + Reports![R_FeeSettlement BalanceTotal]!ctrGrand.Form.tbxSum.
When i use syntax =[R_Fee Settlement BalanceTotal].[Report].[Fee Settlement Balance]+[R_Fee Settlement BalanceTotal].[Report].[Refunds]+[R_Fee Settlement BalanceTotal].[Report].[Medical Assoc Transfer]+[R_Fee Settlement BalanceTotal].[Report].[Returned Checks] it works fine. When i add a syntax for a new subreport thats when i get the error.

[RuralGuy]

What syntax are you adding? Can you post it?

[June7]

Sorry, I mixed Report and Form in the syntax (now corrected post). Instead of Form use Report.

Did you also rename the controls as I suggested?

I just did a quick test of a syntax. It was not necessary to reference the parent form. This worked:

= ctrGrand.Report.tbxSum

However, I am using Access 2007/2010. From what I remember, Access 2003 will accept the syntax.

[Ray67]

I corrected what june7 said but it still doesn't work.
Here is the syntax =[R_Fee Settlement BalanceTotal].Report.[Fee Settlement Balance]+[R_Fee Settlement BalanceTotal].Report.Refunds+[R_Fee Settlement BalanceTotal].Report.[Medical Assoc Transfer]+[R_Fee Settlement BalanceTotal].Report.[Returned Checks]+Reports![R_FeeSettlement BalanceTotal]!ctrGrand.Report.tbxSum

[June7]

Try the revised syntax suggested in my last post. Reference to parent form not needed.

[Ray67]

It still doesn't work.

=[R_Fee Settlement BalanceTotal].Report.[Fee Settlement Balance]+[R_Fee Settlement BalanceTotal].Report.Refunds+[R_Fee Settlement BalanceTotal].Report.[Medical Assoc Transfer]+[R_Fee Settlement BalanceTotal].Report.[Returned Checks]+ctrGrand.Report.tbxSum

[RuralGuy]

Does just ctrGrand.Report.tbxSum give you a value without referencing the other SubReport?

[Ray67]

If i do that i get this message Enter parameter valve ctrGrand