Heres the scenario - any help is appreciated.

i have a recordset that is to a True DB (oledb) grid. One of the rows in the grid is a checkbox. The checkbox needs to be checked for all the records to start. So, i made my select statement something like:

select ..., -1 as letter from... where... etc

and then i bound the letter column on the grid (the checkbox) to the letter column in the recordset.

everything runs smoothly except that when i uncheck the checkbox and move to another record (via downarrow or mouse).. it checks itself again - like i never touched it.

ive also found that if i change the select statement so that part reads ..'1' as letter.. the screen will pull up, all the checkboxes will be checked and i can uncheck them. the problem here happens when i try to check them again. i get a 'data type mismatch' error

thanks for any assistance