Subform Caculation field

[Mukhmoor]

On main form i m using two subforms. On both subforms i m using fields to get sum of amount using sum function n then using these sum amounts on main form for few more calculations. As i update amount fields on subforms, the fields that show the sum of amount goes blank n bcoz of this other fields using tht sum values on main form show wrong values unless i close n reopen form again. I used the requery method as well but nothing is working. Can someone help me in this regard? Thnx

 

[apr pillai]

Try using Me.Refresh statement, rather than me.requery, on the Lost-Focus Event Procedure of one of the fields you are updating on the sub-forms.

 

[Mukhmoor]

Thnx i tried me.refresh, but its not working after updating field "sold price" field on subform1, sumprice field with control source =Nz(sum([Sold price]),0) becomes blank and same happening on the other subform where updating amountpaid field causing sumamount field blank. Both subforms are linked with mainform field saleid, this field exists in all three tables. Can anyone help?

 

[bob fitz]

Hi

I could be wrong but I think you need to use

Me.Recalc

 

[Mukhmoor]

Thnx a lot bob....problem solved.

 

[bob fitz]

Glad to be able to help.