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.

  1. 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.
  2. 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!)

  • No labels