ok. the code below will insert the lessonid and studentids into the table but it leaves the attendance column blank. any ideas why? i cant see the problem..<br>thanks<br><br>Sub btnUpdate_click(sender ...