>that is a different problem. i think you have to tableupdate before calculating the sums... that creates other problems, doesn't it?
>
Actually, I think tableupdate works in this situation. The code is in the save click event so I need to do a tableupdate anyway. In this case I'm just doing it twice.

I was surprised that the SQL SELECT statement did not use the cursor that was already open with the same name.

Jeff