dear professionals

try this:

sql server 2000 backend
adp frontend

form based on a table (not even stored procedure)
one of the table columns is a bit field called "active".
the form contains a checkbox with datasource on this column
if the first action on any record by the user is to click this checkbox
access will crash with
MS Access has detected a problem..." and so on

i can reproduce this situation in various projects, forms, whatever
so: do we have a problem between checkboxes being -1 as true
and bit fields having 1 as true?
if so, what would be the data source of checkboxes then?

thanks for reading, thinking, replying