Wendel,

you were correct on the column allowing nulls. I have changed this to

alter table CaseData Alter column CaseStatus BIT NOT NULL

In regards to setting a default value this is done in access when the new record is created.

I attached a result set from the sql server as an image.

The button's behavior hasn't change though. When I click on the "Closed" button it still disappears. I do notice however that the value in the sql server database changes to a 1 from a 0.

Could the issue be a setting on access such as visibility?