While the compiler doesn't complain, execution fails not being able to recognize the table field name. chkBox is a string variable containing the table's field name. What's the proper syntax for the field assignment? (I tried with and without the brackets. Compiler fails without the brackets.)
Code:rsCol1.Edit rsCol1![ & chkbox & ] = True rsCol1.Update