subtotals from a subform

[cathyc]

I hope someone can help me. I have a form called Project Summary on which I have created a subform called Payments Subform. On the form footer of the Payments Subform I have created a field called Core1Subtotal which calculates the subtotal of a field Core1.

I am now trying to call the field on the Project Summary form below the Payments Subform by using the following as the control source:

=[Forms]![Payments Subform]![Core1Subtotal]

at the moment all I am getting is #Name?

This is an eg that I found in the Northwinds database on their Orders form but when I copy it, I am getting the above message

I hope someone has a solution as I have tried every variation I can think of.....

 

[Rich]

=[Forms]![Project Summary]![Payments Subform]![Core1Subtotal]

 

[cathyc]

Thanks Rich For replying.

I have tried to change the control source as you stated but I am still getting #Name?

 

[Rich]

Then one of the names is wrong, use the code builder for the textbox to get the correct syntax

 

[cathyc]

Subtotal from a subform

HI Rich

I have tried what you suggested and all the references seem to be correct and I am still getting #Name?

I even tried to knock up a simple, cut down version of the form and subform with new queries incase anything was wrong with the originals and still got #Name?

Any suggestions?

 

[cathyc]

Subtotal from a subform

Hi Rich

I have just got it to work and you were right it was a referencing problem as I had renamed the subform. Thanks for all your help.

 

[cathyc]

Subtotal from a subform

Hi Rich

I have just got it to work and you were right it was a referencing problem as I had renamed the subform. Thanks for all your help.