How to add a calclated control to form

R

Renae

I am trying to get a add the column of Rental Amounts into a from. The name
of the subform/subreport is RentalUnitSubform. In design view I have opened
up the subform report.
Subform, I have placed the following in the footer. Label not needed
Text box Name: txtRentalAmountSum
Control Source: =Sum([RentalAmount])
Main Form
Label Box: Name lblRentalAmountTtl
Caption : Total Monthly Income:
Text Box: txtRentalAmountTtl
Control Source: =RentalUnitSubform.Form!txtRentalAmountSum
So I am supposed to get a total of the Rental Amount across form the
Caption: Total Monthly Income: but I get #Error
I have done this on another problem correctly very similar to this. I have
written it all down as to what is typed where and I cna't get it to add the
column Rental Amount.
If you can help great if not, that's the way it goes.
Thanks,
Renae
 
Top