Sum of subform records currency field to main form, getting #Name? error

[jree3000]

I am trying to get a total amount of currency fields in a subform to show in a currency field of my main form. The subform (named "Dose_Tracker_Subform") is a datasheet. I set up a text box in the subform footer (named "subtotal") totaling the field (DosePrice) by putting the following code in the "subtotal" control source: =Sum([DosePrice])

Then I placed the following code in the main form field that I want to display the subform total: =[Forms]![Dose_Tracker_Subform]![subtotal]

However instead of getting a total I get a #Name? error.



What am I doing wrong?

[John_G]

Hi -

You can't refer to a subform that way - it is not part of the Forms! collection.

Use this instead: me![subformcontainername].form![subtotal]

where subformcontainername is the name of the control (on the main form) that contains the subform.

John

[jree3000]

Hi. I don't know what you mean by the name of the control (on the main form) that contains the subform. Are you talking about the actual name of the subform? Also when I try adding that code it keeps changing it to: =[Me]![Dose_Tracker_Subform].[Form]![subtotal]

[John_G]

Are you talking about the actual name of the subform?

No. When you created your main form, you created a container for the subform - a subform/subreport control. It is the name of that subform/subreport control that you would use in place of subformcontainername in the expression.

John

[jree3000]

Okay, I did that but I'm still getting #Name? error.

[June7]

Can't use Me in query or textbox expression, only in VBA. Remove it and see what happens.

[Missinglinq]

How is the DosePrice populated, i.e. is this physically entered by the user or is it a calculated field?

Linq ;0)>

[jree3000]

June7 does it again! I removed the "Me" portion and now it works! Thank you!