I have a field(flow field) that calculate total(sum) value from another table.
Example:
Calcformula : Sum("Table B"."Cost" WHERE (Parent Item No.=FIELD(No.)))
When I change value field Cost in Table B. It's not update in form that
have flowfield.If I want the flowfield to update value,I have to close form and open form again. How to make this form to auto update flowfiedl value when we change field cost in table B?
AAA
0
Comments
It is not possible to update a flowfield automatically when it's value changes.
You can try this to do it "automatically":
-put the TimerInterval-property of the form to a value (e.g. 1000 for each second).
-in the "Form - OnTimer()"-trigger, you can put "CurrForm.UPDATE(FALSE);".
But this has the negative that it becomes very difficult to use the form to update the record. It should be a SHOW-only form.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!