... and an update query doesn't solve the problem because ...

Maybe because your checkbox is unbound? But then all checkboxes show the same value so that wont work.

I don't know.