Reflecting Hdr value as soon as selecting List value(bool)??

pskannaa

Hi,

I need to reflect the header value based on the list form selection...

Header:
Fields : No. , Paid Amount,Cancelled Amount
Line:
No. , TotalAmount, Paid(bool), Cancelled(bool).


Condition is: I hav a list of values in listform If i select the "Paid(bool)" on the List form need to SUM(TotalAmount) in the List and should be reflecting immedialty in the Header form column named "Paid Amount", If i select the "Cancelled(bool)" in the Lists Sum(TotalAmount) in the list which are in Cancelled amount and reflect in the Header field is "Cancelled Amount".


So, finally i come to know which are all the Paid Amount and cancelled amount as soon as user selection on the LIST form should be change the header fields "Paid Amount,Cancelled Amount "

Suggestion Plz.

Regards,
Psk

MBerger

There's no link from a subform to a mainform , so the only way to do this ( i've been down this road too ) is to use a timer to perform a calcfield on the main form to update the value ( assuming you are using a flowfield for the total ).

kine

There is way how to do that without timer and is very good one. It is using Microsoft XML Document automation. See viewtopic.php?f=5&t=7998