Michelle,

Would it work to make the grid based of a view and have the view column be your calculation? In that manner the data would be correct when it grid saw it and you would be able to have the check box funtion as expected.

Just a thought.


>I have a grid that is a checklist. It has two columns: the thing to be done and the check off. The values for the check column come from a character field in another table consisting of T & F. Each thing to be done has a key, and that key number translates to the position in the character string.
>
>For the checkbox, I made the control source:
>
>IIF(SUBSTR(repairview.ccheck,chkkey,1)="T", .T., .F.)
>
>This worked great for displaying the checklist. The problem came when I tried to un/check something. Having a calculated control source seems to make the checkbox read only. Obviously, it's not going to know how to change the value in the string, so I put code for that in the click event. But if I click on the checkbox, it just beeps and doesn't do the click event.
>
>So I set the control source to none, and put "this.value = " plus the IIF above in the refresh event. Unfortunately, it doesn't work dynamically. It takes the result of the first item on the checklist and puts that for all of them.
>
>Is there a way to set the value dynamically without using the control source?
>
>Thanks,
>
>-Michelle