I have table A with a number of check boxes.
For a record in A I want to count how many check boxes are checked giving a number then update field in a corresponding record in table B with that number.
Both tables have same record key field.
I have coded the first part and have the count, but not sure how to code the UPDATE of Table B.
I want to do this as a event of a button click on a form.