Getting the #Name? error and have tried the following:

[rhett7660]

Hello..

I have a form with three tabs.

Event
Personnel Assigned
Break Down

On the event tab I have a txtbox that is supposed to pull from the footer in the break down tab the sum. I can get the sum to work on the break down tab but I can't get it to pull to the event tab. I keep getting the #Name? error.

I have tried the following combinations:

=Forms!frmEventSubGen!txtSumEthnicity

=frmEventSubGen.Form.txtSumEthnicity

=frmEventSubGen!Form!txtSumEthnicity

I even tried the build method and I am still getting the #Name? error. Any suggestions?

 

[emshim]

what is the recordsource of the form?

 

[RuralGuy]

Post back if this link is not helpful enough.

 

[KeithG]

You need to reference the table

forms!formName!TabName!controlName

 

[rhett7660]

Hmmm...

That doesn't seem to be working either.... When I looked at a previous database it had the above code that I posted. For some reason it isn't work on this one.

I just want to show the total that is on a subform on the main form. So at a glance you can see the totals of the other tabs..... It isn't a recordsource, or is it. I just a have a txt box called txtSumEthnicity.... that I want referenced on the main form.....

 

[KeithG]

If the calc is on a subform you need to reference the sub form

 

[rhett7660]

Keith..

I ended up rebuilding the form.. this time it works.... I have no idea what the problem was... I have a feeling it had to do with copy from another form and pasting it into that form.... but anyway.. I figured it out. This code ended up working:

=frmEventSubGen.Form.txt21