CALCFIELDS from SubForm?

Sneakyfall

I have a form with an Flowfield and a subform.

I want to calculate the flowfield in the form from the code in the subform!

Can anybody solve this problem ??

Sneakyfall

mfabian

such as ...
Subform contains a field "Amount" and on the main-form you have a field "Total Amount" which is the sum of all subform-amounts?
As far as I know (there were lot's of discussions about this subject earlier) this is NOT possible as you cannot fire a trigger on the parent form.
Workarounds:
1) on the main form make the calcfields on the OnActivate trigger
2) Use the OnTimer event on the main form in order to have the value recalculated every x milliseconds

---

Marcus Fabian
m.fabian@thenet.ch
+41 79 439 78 72

db

I have one idea, but have problem too <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" />
We need to backup form handle before activating subfom.
in table/rec or form creatiing var Form2147483647 that eq to CurrForm, there backuping main form handle. On modify in subform we calling update.
PROBLEM:
operator := didn't works on forms. How save form handle ???

any suggestions ?

Dave_Cox

Have your total FlowField on your Sub Form Table
Then Adjust your sub form to show the total Field on the top or bottom.

Sub Form

---

Line Total (FlowField)on Form
Colunm/Labels (Table Box)
Line 1
Line 2
Line 3

---

---

MindSource (UK) Limited
Navision Service Partner

david@mindsource.co.uk
info@mindsource.co.uk

[This message has been edited by Dave Cox (edited 18-07-2000).]