Form and subform total

[azimah]

I have a main form (Purchase Requisition) and a sub-form (
details of purchase requisition).The sub-from contents are
Product-id, Unit Price,Currency,Qty to purchase,Total Amt
of each line.
On the main form I have 3 bounded controls ( Total-in-
USD,Total-in-Yen,Total-in-Euro). I manage to get total for
each currency however if a user keep on clicking the Qty
to purchase , the total will keep on increasing.

How do I solve this problem?

Thank you

 

[Kevin Sprinkel]

-----Original Message-----
I have a main form (Purchase Requisition) and a sub-form (
details of purchase requisition).The sub-from contents are
Product-id, Unit Price,Currency,Qty to purchase,Total Amt
of each line.
On the main form I have 3 bounded controls ( Total-in-
USD,Total-in-Yen,Total-in-Euro). I manage to get total for
each currency however if a user keep on clicking the Qty
to purchase , the total will keep on increasing.

How do I solve this problem?

Thank you

I'm not sure what the problem is; post the Control Source
for each of the three main form controls.

The usual method of getting a total for detail records
into the main form is to place a =Sum([fieldname]) control
in the subform's footer, then place a control in the main
form which uses this as its Control Source, e.g., for a
control named curSubtotal in a subform sbfDetails, set the
source to:

=sbfDetails.Form!curSubtotal

HTH
Kevin Sprinkel