>>Hello All!
>>
>>I'm having difficulties with the following;
>>
>>I've a grid populated with data from a table which I create using (without qoutes)
>>
>>"Select fld1, fld2, fld3, blah2.fld4
>>FROM blah1, blah2
>> WHERE blah1.id = blah2.id
>>AND blah2.fld5 = .T.
>>INTO TABLE tmpRoster"
>>
>>.grdRoster.RecordSource = "tmpRoster"
>>.grdRoster.Refresh
>>
>>Now the above works fine. However, I've some code based upon a Dbl Click which upon saving, change blah2.fld5 to .F. When I rerun the SELECT statement, it doesn't reflect the change (i.e. in other words the record still show, but the data has been properly updated).
>>
>>Another thing, when ran in the VFP environment, it works. Within the application, it doesn't.
>>
>>It's driving me crazy as I thought it would be the simplest way to accomplish this task. What am I missing/not seeing? (I didn't add any other code but focused on what gathers the data)
>>
>>TIA,
>>
>>Vernon
>
>Sorry, blah2.fld5 should be blah2.fld4

Try adding

this.value = this.value in the DblClick event or InteractiveChange event of the checkbox.