Continuous subform and calculation.

[ovim via AccessMonster.com]

I have a form and a continuous subform in it. On the subform you can list the
type and amount of purchased items. At the end of each row theres a field
which calculates the subtotal for each row. At the footer of the subform
theres a field which calculates the sum of all subtotals.

It almost works. The only problem I have is that if I select a product and
amount and move straight to Mainform the total price (in the footer of the
subform) is not calculated correctly (but the subtotal is).
It only works if I move one row up or down from the row I edited. If I use
SetFocus to move to the first field (column) on the row it also moves to the
first row and of course the total is calculated, but then I have to move back
down to the next row I'm going to fill.

Is there anything I can do about this?

 

[Albert D. Kallal]

Try placing a

me.Refresh in the sub-form control's on exit event.

(note that I said the sub-form control...not the actual sub-form).