H
Hing
A subform is a list of ordered items with a field "Extended Price". At a bottom, a field "sGrandTotal" is the sum of the Extended Price.
A main form with a variable named "mGrandTotal" and this is the reference of the sGrandTotal.
The problem is, if I update any information regarding the Extended Price such as the Quantity, the sGrandTotal cannot update immediately. This ONLY happened if the window size of subform is not large enough for displaying all the records.
If either the number of record is lesser or the window size of subform is larger, the problem is gone. However, it is not suitable when I create many records in a window, say, 17 records.
Can anybody solve this problem?
A main form with a variable named "mGrandTotal" and this is the reference of the sGrandTotal.
The problem is, if I update any information regarding the Extended Price such as the Quantity, the sGrandTotal cannot update immediately. This ONLY happened if the window size of subform is not large enough for displaying all the records.
If either the number of record is lesser or the window size of subform is larger, the problem is gone. However, it is not suitable when I create many records in a window, say, 17 records.
Can anybody solve this problem?