Thanks a lot EHW..........................
I got it working partially thanks to your kind help.
When added new records, editing etc it seems to be loosing its checkbox logic, more likely I couldn't work out the logic properly or implemented incorrectly. It may look strange on sample project as to why I'm using checkboxes as radio buttons instead of combobox. I need to do something with checkboxes (radiobuttons) as it suits the part of the project better.
There is another issue on doubleclick. If the record selected with mouse click on tGrid (active focus) it seems to be working OK most of the time. However, when double clicked while there is a passive focus on tGrid record (when leaving the form and coming back to it after save etc) then it looses it's logic to show correct checkbox checked. I added set focus on show to avoid passive focus but didn't help much.
Please see the attached sample project:
Adam
God... please help me become the person my dog thinks I am.