I have an Access 2000 application which includes a form to add new records to a certain table. On that form there is a checkbox which has a default of False (I have also tried 0 [zero]). The form has a select query as it's record source, with each object on the form tied to the appropriate field via it's control source. For adding each new record I make use of RunCommand acCmdSaveRecord. Now to the specific problem...
The system has an SQL Server 2000 database. Every field in the table in question gets added correctly except for the checkbox field (if left untouched by the user, i.e. in it's default unchecked state). When you look at the table the field contains a zero as would be expected for a false (unchecked) checkbox, however a query with a criteria of [CheckboxField] = False does not include the newly added record. However if you go into the table, delete the zero and type a zero yourself, the query includes the record !!
I think I will have to just run a query as part of the add process to assign a value of zero (if the checkbox is false on the form) AFTER the record has been added to the table, but I wanted to know if anyone has come across this before and knows the reason and the proper solution.
The system has an SQL Server 2000 database. Every field in the table in question gets added correctly except for the checkbox field (if left untouched by the user, i.e. in it's default unchecked state). When you look at the table the field contains a zero as would be expected for a false (unchecked) checkbox, however a query with a criteria of [CheckboxField] = False does not include the newly added record. However if you go into the table, delete the zero and type a zero yourself, the query includes the record !!
I think I will have to just run a query as part of the add process to assign a value of zero (if the checkbox is false on the form) AFTER the record has been added to the table, but I wanted to know if anyone has come across this before and knows the reason and the proper solution.