Refer to a Sum in Subform2 from Subform1

[Mail Merge Help]

Hi

I have a MainForm with 2 subform1 and Subform2.

In subform2, is continous form. I have done a calculation of all the control
to show the sum in the Form footer and name it's txtWeighting

In subform1, I have a controlname that I want to set the the default to the
txtWeighting in Subform 2. If user disagreed, they can override the value.

I have set the Default Value
=[forms]![Mainform]![Subform2].[form]![txtWeighting].

But it didn't work. Could anyone please help tell me what's wrong with this.
I am using Access2003.

Thanks
HN

 

[RonaldoOneNil]

Take the equals sign away from the front
[forms]![Mainform]![Subform2].[form]![txtWeighting]

 

[Mail Merge Help]

Hi

Thanks for replying, but it didn't work. In Default Value in Subform1

[Forms]![Mainform]![Subform2].[Form]![txtWeighting]

Can anyone help.
Thanks

 

[RonaldoOneNil]

It works OK in mine. I set it up to test before I posted. Don't know what
else to suggest except is Subform2 the actual name of your form in the main
form and not simply the name of the form as a stand alone ?
When you say it didn't work, what appears in the box ?

 

[Mail Merge Help]

Hi

The exact full name is:
[Forms]![ApF00_BranchObjectives1]![ApF00_RiskRankingSub].[Form]![txtWeighting]

Where ApF00_BranchObjectives1 is the name of the Main Form
Apf00_RiskRankingSub is the name of the subform 2
txtWeighting is the calculated controlName in subform2 that I want to
displace in the txtRisk in subform1

Thanks

It works OK in mine. I set it up to test before I posted. Don't know what
else to suggest except is Subform2 the actual name of your form in the main
form and not simply the name of the form as a stand alone ?
When you say it didn't work, what appears in the box ?

Hi

Thanks for replying, but it didn't work. In Default Value in Subform1

[Forms]![Mainform]![Subform2].[Form]![txtWeighting]

Can anyone help.
Thanks