calculated sum

[Charlie2]

Ok I am trying to do a calculation on my main form totalling some amounts.
On my sub form the control source is =Sum([Amount]) my subform is named frmWarrantyListSubform, the Textbox on the footer of the subform is named txtWarrantySubform.

My main form is named frmProvider, my control source for the textbox on the footer of main form is =frmWarrantyList Subform.Form!txtWarrantySubform.
The name of the textbox on my main form is txtWarrantyMain.

I run the form and I get #Error displayed, what is my problem?


Charlie

 

[Rich]

=[Forms]![MainFormName]![frmWarrantyList Subform].[Form]![txtWarrantySubform]

 

[Charlie2]

I still get an error

I used =[Forms]![frmProvider]![frmWarrantyList Subform].[Form]![txtWarrantySubform]


I thought it would work that time.
I also tried =[Forms]![txtWarrantyMain]![frmWarrantyList Subform].[Form]![txtWarrantySubform]

Oh god this cracks me up.

Thanks for the advice anyway Rich

 

[Charlie2]

AaaAAAaAGGggh Ive got it

I didnt realise the =Sum([Amount]) had to refer to a column.
The column that I want totalled is called Warranty Charge, so I simply changed the subform control to =Sum([Warranty Charge]) and my original vers works. =[frmWarrantyList Subform].Form!txtWarrantySubform



Signed Mr Happy.