if I set the controlsource of the column to the field, it doesn't update the cursor and if I set the controlsource of the checkbox to the field I get a data type mismatch when selecting the checkbox.

Is the column's ControlSource specified as Alias.Field or just as the field name? Make sure you qualify the column's ControlSource with the alias.