Totals box in a form

[millerlite2ky]

Is there a way that I can get a Total or a Sum put on a form, from the records being displayed in a Subform?

Scott

 

[smozgur]

Hi Scott,

Say you have a subform named as "mysubform".
You want to get total of values in a field resides in mysubform's detail section. And this field's name is "myfield".

1- Display Header and Footer in subform (right click on detail and point to Form Header/Footer).
2- Create a textbox on subform Footer and name it as "mytotal".
3- Change mytotal ControlSource property as following

=Sum([myfield])

4- Goto parent form and create a text box on it.
5- Change this new textbox's ControlSource property as following

=[mysubForm].Form.mytotal

That's it. I hope it helps.

Suat

 

[millerlite2ky]

My main form text box shows the #Name? in it. Any ideas?

Scott

 

[smozgur]

You can send me your partial database that has required objects in it to let me set it for you if you like.

smozgur-at-tnn.net

Suat

 

[smozgur]

Hi Scott,

It should be my missing description. we should use subform object name in form, not subform's form name.

[Results] = subform object name in your main form so we should use :

=[Results].Form.racetotal

in the main form text box ControlSource property.

Suat