>>
Harry,
>>The other form's datasession ? Is it same as this one ?
>
>both set to 1
>
>>BTW why reset recordsource to "Journal" ? Isn't it already "Journal" ? Also you can do both sum in one :
>>sum cred, deb to thisform.totcredits, thisform.totdebits
>
>thereyago. another trick learned. Is there a performance benefit?
>
>Harry
Harry,
I'm disappointed to see it's not a datasession problem (not totally sure though).
For sum performance gain would be for you do it in one pass. IMHO I would prefer SQL if not buffered (really if buffered too, and also change result textbox.value with value - oldvalue + newvalue Oldvalue and newvalue are the values of current field that affect the total).
Cetin