Binding A VB CheckBox To MS Access Data Table

[Developer Dude]

Hi:

I have an Access data table with one of the fields as a "Yes/No" type. The user interface is a VB form.

I cannot get the binding to work right and the insert and update don't work. This is the code to bind

the checkbox to the data.

chkSE_OR2.DataBindings.Add("Checked", bsSE, "SE_OR2_CHK")

This is part of the insert command code.

SE_InsertCommand.Parameters.Add("@SE_OR2_CHK", OleDbType.Boolean, 1, "SE_OR2_CHK")

This is part of the code for the update command.

SE_UpdateCommand.Parameters.Add("@SE_OR2_CHK", OleDbType.Boolean, 1, "SE_OR2_CHK")

I would really appreciate some help here.

Thanks so much.

Continue reading...