Control source for text box on a form

[wildexodus]

I have a form with a text box on it and also a subform. I want the text box to calculate the sum of a field in the subform. What is the control source code for this?

 

[jfgambit]

=Sum([Forms]![subFormname]![subformtextboxname])

Change names accordingly...

 

[wildexodus]

tried that. It says #error.

Its frmOrder

 

[Elana]

FYI - The sample Northwind database has an example of how to do this...on the form called Orders.

 

[jfgambit]

Looking at your Form, you are trying to Sum based on the Form Footer. You need to add a Footer for the Order Number, then Sum this on your subform. You can then point the Main form to this subform box.

Hope that makes sense. If you need an example, see the Northwind sample DB.

 

[jfgambit]

He...nice Elana...just missed your post...

 

[chewy]

would this work?

me!yourSubformName.form!yourTextboxName

 

[wildexodus]

would this work?

me!yourSubformName.form!yourTextboxName

No, it brings up #Name in the txt box.

 

[Rich]

=Sum([YourField]) as the control source of an unbound textbox in the subform footer

 

[wildexodus]

I've done that but i still get #error in the text box thats on the main form.

I've looked at the northwind and done what they've done but its still not working. I think i may have missed something somewhere.

 

[Rich]

What's the control source of the textbox on your main form?

 

[wildexodus]

It's:

=[frmOrderSubform].[Form]![txtsub]

but it keeps changing itself to:

=frmOrderSubform.Form!txtsub

 

[Elana]

The error is occurring in your subform subtotal text box - not in the reference to the text box. I'm looking at it and trying to figure it out.

 

[Rich]

=[frmOrderSubform]![txtsub]

 

[wildexodus]

#error

!!!

 

[Elana]

Set the control source of txtSub to =sum([expr1])

 

[wildexodus]

Thankyou so much! That works perfectly!