#Name? Error on main form with calculated value from subform footer

[kolsen]

I have a main form with a subform
Main form called Tracker, with a subform called TrainingSubForm.


The footer of TrainingSubform has a calculated field [Total Hours] (a sum) which calculates nicely and displays in the subform footer when I view the subform.

On the main form the embedded subform does not display it's footer as it is displayed as a datasheet. (not sure if this is the issue.
I wanted to display that calculated field on the main form but I get #Name? error when I set up a field with control source =[Forms]![TrainingSubForm]![Total Hours]

Kimberly

[ItsMe]

Maybe try something like ...

=[Forms]![MainFormName]![TrainingSubForm].[Form].[Total Hours]

[Missinglinq]

I always refer to an archived file, when doing this, or else I get tangled up, and it states that the syntax would be

=TrainingSubForm.Form![Total Hours]

Linq ;0)>

[John_G]

You can't refer to a subform using Forms![TrainingSubForm]![Total Hours], because subforms are not a part of the Forms! collection.

Instead, you use the name of the control on the main form that contains the subform. Your reference to the subform and its control will look like this:

=[controlname].form![total Hours], where controlname is the name of the control on you main form.

It is important to note that the subform is not referred to by its name (in your case TrainingSubForm)

[Missinglinq]

Unless the names of the Subform Control and the Subform, itself, are one and the same...which is why it's probably a good idea to give the Subform Control a name different from the Access assigned name, which is the same!

Linq ;0)>

[kolsen]

Unless the names of the Subform Control and the Subform, itself, are one and the same...which is why it's probably a good idea to give the Subform Control a name different from the Access assigned name, which is the same!

Linq ;0)>

Thanks. I am out of the office for a few days but will give that a try on my return. There is so much incorrect information about this online

[kolsen]

Worked well thanks

[Missinglinq]

Glad we could help!

Good luck with your project!

Linq ;0)>

[orange]

This link is also a good reference for referring to forms/subforms.