Update field Value

[Guest]

I have a form with a subform. This subform has datasheet view and the fields,
product quantity and value.
At the footer of the subform I have a calculated field (total amount)
summing Quantity*Price. On the main form I have a calculated field wich data
source is Subform’s total ammount. The subform total amount is not visible.
I need the total amount field to be updated when the quantati or value is
changes.

I have tried the after update event running this code:
Me.Soma.Refresh, but it returns method or data member not found error.

Is there any other way for having this field real time updated?

 

[Marshall Barton]

I have a form with a subform. This subform has datasheet view and the fields,
product quantity and value.
At the footer of the subform I have a calculated field (total amount)
summing Quantity*Price. On the main form I have a calculated field wich data
source is Subform’s total ammount. The subform total amount is not visible.
I need the total amount field to be updated when the quantati or value is
changes.

I have tried the after update event running this code:
Me.Soma.Refresh, but it returns method or data member not found error.

Is there any other way for having this field real time updated?

Refresh is a form method, it does not apply to individual
controls.

I think the recalculation will take place automatically, but
it can take a significant amount of time. Try using the
Recalc method instead.