How to sum a text box located in a subform

H

HL

I have a form called OrderRequest that contains a text box called
TotalClothingPieces. The OrderRequest form also contains a subform called
ClothingItems. The subform is displayed in the datasheet view and has three
columns one called Quantity.

After the user inserts a value in the Quantity column (located in the
subform), I want my TotalClothingPieces text box to update with the
appropriate value. For example, if the sum value in the Quantity column is
10 then I was that value to be displayed in the TotalClothingPieces text box.


Please tell me how to do this.

Thanks in advance.
 
A

Al Camp

HL,
In subform design view, add an unbound text control in the FormFooter to
calculate the sum of all Quantity values in the subform. (Quantity is
assumed to be a bound text control with an entered value... not a calculated
field)
=Sum(Quantity)
Quantity is assumed to be a bound text control with an entered value...
not a calculated field.
Call that sum field TotalClothingQuantity.

On the Main form, place an unbound calculated field with a ControlSource
of...
= Forms!OrderRequest!ClothingItems.Form!TotalClothingQuantity
 
J

John Vinson

I have a form called OrderRequest that contains a text box called
TotalClothingPieces. The OrderRequest form also contains a subform called
ClothingItems. The subform is displayed in the datasheet view and has three
columns one called Quantity.

After the user inserts a value in the Quantity column (located in the
subform), I want my TotalClothingPieces text box to update with the
appropriate value. For example, if the sum value in the Quantity column is
10 then I was that value to be displayed in the TotalClothingPieces text box.
Click to expand...

You'll need to put a control (which need not be visible) in the
subform's Footer. Let's say you name it txtTotalQuantity. Set its
Control Source to

=Sum([Quantity])

Then, set the control source of TotalClothingPieces to

=mysubformname.Form!txtTotalQuantity

Note that TotalClothingPieces should generally NOT be stored in your
table - just calculate it as needed.

John W. Vinson[MVP]
 
Top