I am using ADO in a VB6 application connecting to an Access 2000 database. When I am updating a form with record data, the recordset pointer will move from the current record to the first record when I try to update a checkbox in the form. If I comment out the checkbox code the recordset pointer stays put. I am certain I am not trying to set the checkbox with a -1 value.
Is this an ADO bug or do I need to figure out a way to copy just the record I want into a new recordset before I update the form?
Thanks in advance,