Refer to a Sum in Subform2 from Subform1


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
 
Ad

Advertisements

R

RonaldoOneNil

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

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
 
R

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 ?
 
Ad

Advertisements

M

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top