>>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
don't know if you can tell it to do that or not, but the 'regular route' for sql is to the tables, not to opened views...