Subform Not Accepting changes only for New Records Added

[sross81]

I have a subform that has 3 check boxes. If the record was an existing record in the SQL table and I want to change the value I can change it no problem. If I try to check the box for a new record added to the database then it doesn't allow me to save the change. I know that this is a problem with bit values in SQL when deleting so I made sure all 3 fields have a default value, but it still doesn't let me make changes to new records. Has anyone experienced this?

 

[sross81]

Nevermind. YOu have to change every field in the table that is a bit datatype to have a default value and if anything has already been inserted as null you have to update all of those records. Then you can edit and delete. Otherwise it will keep giving you an error saying that it is still being edited.