Summing on main form

[grenee]

Good day all.

My main form is "Invoices" and its subform is "Customer Payments". "Customer Payments" has a field "Payments". Can anyone guide me how to sum the "payments" field but displaying the results in a calculated field on the main form.

I even tried summing on the subform but that calculated field does not display and even when it is reference from the mainform it displays an error.

Can anyone help?

 

[spikepl]

http://bfy.tw/1WD5

 

[grenee]

Thanks. This works.