title: Datasheet View insert value in to field when checkbox is checked
body: <p>I have a form as a Datasheet View and inside I have added a column for checkbox.</p>
  
  <p><a href="https://i.stack.imgur.com/BQJ61.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BQJ61.png" alt="Datasheet View rows ms-access"></a></p>
  
  <p>Let us say that the column with check-boxes is column A and the one from the right it is column B.</p>
  
  <p>How can I insert some text in column B when the checkbox from column A is marked as checked. I need somehow to find out the current row on witch the checkbox is and take the ID for the record from the row on with checkobox is and run a SQL insert for that specific ID in the database table, something like: SQL = "UPDATE table SET columnB='string' WHERE ID= ROWid;"</p>
  
  <p>How can I do the row selection part from the datasheet view?</p>