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