VBA Form with Linked Table

Hello everybody, I'm a VB developer with about 4 years experience and I've never seen this problem anywhere.

I've got an Access DB that is acting as a front end to a SQL database. There is a form that contains 2 subforms that contains a tables, no queries or joins just a simple tables. The bottom form has a checkbox that is bound to a bit record in the SQL database. When I click on the checkbox, I can no longer goto another record, I'm stuck on that one until I close and restart the form. If I try to update one of the textfields instead of the checkbox, than it works find and I can move to other fields immediately afterward. The top subform contains almost the exact same components just a different table and it works fine. If anyone could help me out with this it would be great. Thank you.
tolkien266@netzero.com