
Updating field in form from summary value in another
Please help me out here folks...
I've got two forms on the same page of a tab control. Form
1 has the field [Price] on it. Form 2 has the field
[Componentprice] on it. In Form 2's footer, I have a sum
(Componentprice) function in a field [Comppricesum]. The
function is summing fine.
I would like the [Price] field to get the new total every
time I add or change the component prices. I have attached
an assign statment to the "AfterUpdate" event of Form 2,
to get Form1![Price] = Form2![CompPriceSum]. What happens
is that [Price] always gets the previous value of
[CompPriceSum] instead of the current one.
Thanks in advance -