Sum in Subform & Main Table #Name?- HELP!

W

wvhines

I'm using Access 2003 and I have a subform within a subform and I keep
getting #Name?

Main Subform is "frmsubContractors"
Other Subform is "frmsubContractors2Agree"
and in the frmsubContractors2Agree I have a total currency field
in the footer called "calcTotalAwardsContract"
The control source of "calcTotalAwardsContract"
=nz(Sum([fldawardamt]),0) which works great

However when I refer to the "calcTotalAwardsContract" field in the
main subform with a field named "calcTotalInitialAward" with a control
source of
=frmsubContractors2Agree.Form!calcTotalAwardsContract I get #Name?

Please help, I've tried this several different ways, I read numerous
posts on this subject and I may get #Error instead of #Name?, or if I
base my main subform off of a query the main subform only appears some
of the time but nothing seems to work.

Your earliest possible attention concerning this matter is GREATLY
appreciated.

- Wilma
 
L

luanhoxung

I'm using Access 2003 and I have a subform within a subform and I keep
getting #Name?

Main Subform is "frmsubContractors"
Other Subform is "frmsubContractors2Agree"
and in the frmsubContractors2Agree I have a total currency field
in the footer called "calcTotalAwardsContract"
The control source of "calcTotalAwardsContract"
=nz(Sum([fldawardamt]),0) which works great

However when I refer to the "calcTotalAwardsContract" field in the
main subform with a field named "calcTotalInitialAward" with a control
source of
=frmsubContractors2Agree.Form!calcTotalAwardsContract I get #Name?

Please help, I've tried this several different ways, I read numerous
posts on this subject and I may get #Error instead of #Name?, or if I
base my main subform off of a query the main subform only appears some
of the time but nothing seems to work.

Your earliest possible attention concerning this matter is GREATLY
appreciated.

- Wilma
Click to expand...

Try with:
Forms!frmsubContractors!frmsubContractors2Agree.Form!
calcTotalAwardsContract
Or Me.frmsubContractors2Agree.Form!calcTotalAwardsContract

Luan.
 
W

wvhines

I'm using Access 2003 and I have asubformwithin asubformand I keep
getting #Name?
Click to expand...
MainSubformis "frmsubContractors"
OtherSubformis "frmsubContractors2Agree"
and in the frmsubContractors2Agree I have a total currency field
in the footer called "calcTotalAwardsContract"
The control source of "calcTotalAwardsContract"
=nz(Sum([fldawardamt]),0) which works great
Click to expand...
However when I refer to the "calcTotalAwardsContract" field in the
mainsubformwith a field named "calcTotalInitialAward" with a control
source of
=frmsubContractors2Agree.Form!calcTotalAwardsContract I get #Name?
Click to expand...
Please help, I've tried this several different ways, I read numerous
posts on this subject and I may get #Error instead of #Name?, or if I
base my mainsubformoff of a query the mainsubformonly appears some
of the time but nothing seems to work.
Click to expand...
Your earliest possible attention concerning this matter is GREATLY
appreciated.
Click to expand...
- Wilma
Click to expand...

Try with:
Forms!frmsubContractors!frmsubContractors2Agree.Form!
calcTotalAwardsContract
Or Me.frmsubContractors2Agree.Form!calcTotalAwardsContract

Luan.- Hide quoted text -

- Show quoted text -
Click to expand...

No luck Luan,

I've tried your top 2 suggestions in the control source of field
"calcTotalInitialAward" on
"frmsubContractors" along with the othe 6 below and nothing seems to
be working.
I still get #Name?

I am truly stumped and getting desperate as you can see in some of my
code below.
Any other ideas?

(1) =Forms!frmsubContractors!frmsubContractors2Agree.Form!
calcTotalAwardsContract

(2) =Me.frmsubContractors2Agree.Form!calcTotalAwardsContract

(3) =Forms!frmsubContractors2Agree!frmsubContractors.Form!
calcTotalAwardsContract

(4) =Forms!frmsubContractors2Agree!calcTotalAwardsContract.Form!
frmsubContractors.calcTotalInitialAward

(5) =Forms!frmsubContractors2Agree.Form!calcTotalAwardsContract

(6) =Forms!frmsubContractors2Agree.calcTotalAwardsContract

(7) =Forms!frmsubContractors2Agree!calcTotalAwardsContract

(8) =frmsubContractors2Agree.Forms!calcTotalAwardsContract

- Wilma
 
W

wvhines

On Mar 2, 8:00 am, [email protected] wrote:
I'm using Access 2003 and I have asubformwithin asubformand I keep
getting #Name?
MainSubformis "frmsubContractors"
OtherSubformis "frmsubContractors2Agree"
and in the frmsubContractors2Agree I have a total currency field
in the footer called "calcTotalAwardsContract"
The control source of "calcTotalAwardsContract"
=nz(Sum([fldawardamt]),0) which works great
However when I refer to the "calcTotalAwardsContract" field in the
mainsubformwith a field named "calcTotalInitialAward" with a control
source of
=frmsubContractors2Agree.Form!calcTotalAwardsContract I get #Name?
Please help, I've tried this several different ways, I read numerous
posts on this subject and I may get #Error instead of #Name?, or if I
base my mainsubformoff of a query the mainsubformonly appears some
of the time but nothing seems to work.
Your earliest possible attention concerning this matter is GREATLY
appreciated.
- Wilma
Click to expand...
Click to expand...
Try with:
Forms!frmsubContractors!frmsubContractors2Agree.Form!
calcTotalAwardsContract
Or Me.frmsubContractors2Agree.Form!calcTotalAwardsContract
Click to expand...
Luan.- Hide quoted text -
Click to expand...
- Show quoted text -
Click to expand...

No luck Luan,

I've tried your top 2 suggestions in the control source of field
"calcTotalInitialAward" on
"frmsubContractors" along with the othe 6 below and nothing seems to
be working.
I still get #Name?

I am truly stumped and getting desperate as you can see in some of my
code below.
Any other ideas?

(1) =Forms!frmsubContractors!frmsubContractors2Agree.Form!
calcTotalAwardsContract

(2) =Me.frmsubContractors2Agree.Form!calcTotalAwardsContract

(3) =Forms!frmsubContractors2Agree!frmsubContractors.Form!
calcTotalAwardsContract

(4) =Forms!frmsubContractors2Agree!calcTotalAwardsContract.Form!
frmsubContractors.calcTotalInitialAward

(5) =Forms!frmsubContractors2Agree.Form!calcTotalAwardsContract

(6) =Forms!frmsubContractors2Agree.calcTotalAwardsContract

(7) =Forms!frmsubContractors2Agree!calcTotalAwardsContract

(8) =frmsubContractors2Agree.Forms!calcTotalAwardsContract

- Wilma- Hide quoted text -

- Show quoted text -
Click to expand...

The strangest thing just happened it works!
I'm not sure what I did, I started working on something else and when
I looked at it again I saw it working. The code below is what ended
up working.

=frmsubContractors2Agree.Form!calcTotalAwardsContract
 
Top