How to reference a sub-report within a report

"R_Bonus_Incentive_First_Half.Report!Total_Payout1 <<--- DOES NOT WORK"

Any error messaage?

Hi hnasr. I tried five different ways, but none of them work.
1)
ControlSource=[Other_Payout_Jan-Dec]+R_Bonus_Incentive_First_Half.Report!Total_Payout1
        Result:  It prompt to input a value when the report is opened and  #Name?appear on the field,.
2))/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
ControlSource=[Other_Payout_Jan-Dec]+Reports!R_Bonus_Incentive_1!
                         R_Bonus_Incentive_First_Half.Report!Total_Payout1      
        Result:  It prompt to input a value when the report is opened and #Name? appear on the field.
3))/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
ControlSource=[Other_Payout_Jan-Dec]+Reports!R_Bonus_Incentive_1!
                         R_Bonus_Incentive_First_Half!Total_Payout1            
        Result:  It prompt to input a value when the report is opened and  #Error appear on the field.
4)/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
ControlSource=[Other_Payout_Jan-Dec]+R_Bonus_Incentive_First_Half!Total_Payout1               
        Result:  It prompt to input a value when the report is opened and #Error appear on the field.
5))/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
ControlSource=[Other_Payout_Jan-Dec]+Reports!R_Bonus_Incentive_First_Half!Total_Payout1
       Result:   It prompt to input a value when the report is opened and #Name? appear on the field.

lin100,

You never stated if you tried my suggestion?

JeffCoachman

Hi boag2000. I will try your suggestion later, but I do not think issue is with null and blank on a field to where I have to use the NZ function. All of the numeric fields on the report has a numeric value. There is no empty field. Some field has a zero (0), while others have number greater than zero.

I see you are using expressions, with + operator.
Try each part of the expression and check which part is producing the error!

I did use the NZ function and a dialog box prompt me to put in the value for
R_Bonus_Incentive_First_Half. When I clicked the OK button the report opened,
and the field Total_Payout2  has the value    #Name?   in the text box.
     The   NZ(Reports!R_Bonus_Incentive!R_Bonus_Incentive_First_Half.Report!Total_Payout1)
     does not work. The NZ function has no relevant here.

Access think that R_Bonus_Incentive_First_Half is a parameter when in fact it is a subform
within a main form named "R_Bonus_Incentive".
////////////////////////////////////////////////////////////////////////////////  
Sub Report Name : R_Bonus_Incentive_First_Half
Field Name: Total_Payout1
ControlSource: =Sum([Payout_Value])
Location of Field Total_Payout1: Report Footer
////////////////////////////////////////////////////////////////////////////////  
Main Report Name: R_Bonus_Incentive
Field Name: Total_Payout2
ControlSource: =NZ(Reports!R_Bonus_Incentive!R_Bonus_Incentive_First_Half.Report!Total_Payout1)
Location of Field Total_Payout2: Detail Section

I am attaching a small access database that have the problem above.
Open a report named R_Bonus_Incentive.
The field Total_Payout2 is the problem.