I have a form which contains a subform. With in the subform there are sets of records which I want to calculate a grand total in the main form in a textbox. I have tried using a textbox on the main form, then using a expression with out success. Can anyone help!!
textbox in form
- Thread starter IanT
- Start date
Fizzio
Chief Torturer
- Local time
- Today, 22:20
- Joined
- Feb 21, 2002
- Messages
- 1,884
Do you just want to total the values in the current record or overall total for all records?
If just the total of the current values, you could try this
In the subform footer create a hidden textbox =Sum([FieldYouWantToTotal])
In the mainform create an unbound textbox with the controlsource set to refer to the hidden control on the subform.
If overall, look up the DSum function.
HTH
If just the total of the current values, you could try this
In the subform footer create a hidden textbox =Sum([FieldYouWantToTotal])
In the mainform create an unbound textbox with the controlsource set to refer to the hidden control on the subform.
If overall, look up the DSum function.
HTH
