Eric,

In the interactive change method of the checkbox, in the grid, I have:

=tableupdate(.t.) && just to make sure
=thisform.GetTotal() && sum method

The odd thing, is that there is a command button on the form to create a file based on the rows in the grid that are checked. If I uncheck 1 row, then click the button, the created file has the right items in it. But the total shown still includes the item I unchecked.

PF

>>I have a grid based on a remote view created with sql pass through. I add a logical field in the sql statement as the purpose of the grid is to check off the rows that are to be included in a report.
>>
>>The view is marked .f. for update since all I'm doing is outputing certain records. The problem I'm having is that I want a running total of all the records checked.
>>
>>I have a form method that does a sql select sum.... based on the logical field. The problem I'm having is that no matter where I put a call to the sum method, the sum doesn't take into account the check / uncheck that just occured. It is based on the check / uncheck before. I.E. the 1st click on the checkbox does nothing, the 2nd click shows the total as the amount from the 1st invoice, the 3rd click shows the total as the amount from 1 + 2, etc.
>>
>>Anyone have any suggestions? Thanks,
>>
>>PF
>
>Where are you calling the SUM mehod from? What happens if you put in a commandbutton on the form?