I have created a connection to a MS Access database. The table that I'm connecting to has 10 fields. 2 of the 10 fields are checkbox fields. In my MS Access table the value is -1 when it checked and 0 when it is not checked. I have created 2 buttons (previous and next) to navigate through the records. My MS Access table has 122 records. When selecting the previous and next buttons, I can only get to record 20. Record 20 happens to be where the first instance of the check box should be displayed and checked. The checkbox doesn't get displayed on the form and the previous and next buttons no longer work. Any ideas?
