I have attached a subform to a form. On the subform I have 2 input fields (a and b), and a calculation field to calulate the product of the two input fields (c).
Whenever, I edit the values of the 2 input fields, the calcalution field (c) updates with the correct calculation.
- However, the calculation fields which I put on the main form(d and f) are not being updated, if a make changes to the input fields on the sub form. That is to say the first time on creating a new record everything works fine but on changing the values after the initial calculation, it does not work anymore.The correct values are not shown until I save the form and edit the form again.
- In addition, a calculation field does not work when I try to use a calculationfield on the mainform based on another calculation field on the mainform for which its underlying value is from a calculation field on the subform. See example below,
Subform
a 10
b 20
c 200 (a*b)
Main form
d 200 (c)
e 10
f 210 (c +e) (d +e does not work!)