Getting the Totals

[trident]

I have created a main form (A) where in what is included a subform (B) with totals.

Subform shows:


Unit Price (Number)
Quantity (number)
Total Price (Unit Price x Quantity)

On the main form - there is a field that is for discount and Grand Total

The Grand total should show the formula
Grand Total = Total Price (which is in the subform) - Discount

As a sample:

SN Unit Price Quantity Total Price
1 2.00 8 16.00
2 3.00 9 27.00
3 4.00 10 40.00

Discount : 8.00
Grand Total : 32.00

How can i get the Total Price from the subform and show it to the main form.

Thank you in advance

Trident

[Bob Fitz]

How can i get the Total Price from the subform and show it to the main form.

Create a textbox in the footer section of the subform to calculate the total. Name it TotPrice. Set its record source property to =Sum([Total Price])
Total Price should be the name of the textbox which shows the line total.
Create a textbox on the Main form and set its record source property to reference the textbox called "TotPrice" on the subform footer.
We would need to know the name of the main form and the subform control to help more but would be something like:
= Forms.[NameOfMainForm].[NameOfSubformControl].Form.TotPrice

[CJ_London]

you can refer to the subform directly, so instead of

= Forms.[NameOfMainForm].[NameOfSubformControl].Form.TotPrice

you can use

= Me.[NameOfSubformControl].Form.TotPrice

[trident]

I followed the instruction to the letter bu still #ERROR appears:

1. created a textbox in the subform footer and named it TOTPRICE
1.1 entered formula for TOTPRICE=([TOTAL PRICE])

2. created a textbox in the main form and named it GrandPrice
2.1 entered the same formulas as shown above but still #ERROR

When I checked the properties, there is no RECORD SOURCE PROPERTY. in the Data, there is only Source Property and this is where I placed the formulas.

No result, where is my error. I really can not see it.

Help Please.

Trident

[CJ_London]

not quite

1.1 entered formula for TOTPRICE=([TOTAL PRICE])

should be

1.1 entered formula for TOTPRICE=SUM([TOTAL PRICE])

If that doesn't work, try

=SUM([Price]*[Quantity]) - changing names to match yours

not clear from your post but it does need to be =SUM(....

[CJ_London]

Also

2.1 entered the same formulas as shown above but still #ERROR

should be

= Forms.[NameOfMainForm].[NameOfSubformControl].Form.TotPrice

or

= Me.[NameOfSubformControl].Form.TotPrice