Refer to a Sum in Subform2 from Subform1

  • Thread starter Thread starter Mail Merge Help
  • Start date Start date
M

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
 
Take the equals sign away from the front
[forms]![Mainform]![Subform2].[form]![txtWeighting]
 
Hi

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

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

Can anyone help.
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

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

RonaldoOneNil said:
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 said:
Hi

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

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

Can anyone help.
Thanks
Click to expand...
Click to expand...
 
Back
Top