Update a checkbox?

[brendalisalowe]

How do you update a checkbox? This is what I have, but it doesn't work:

        Update_tblCapRec = "UPDATE tblCapRec SET InGDB = cbInGDB.Checked WHERE CaseNumber='" & txtCaseNum.Text & "'" & " AND PartNumber ='" & txtPartNum.Text & "'"

Thanks!

[brucevde]

What is the datatype of InGDB?

Regardless, you need to concatenate the vaule of the CheckBox to the SQL string, like you do for the Case and Part Numbers.


Update_tblCapRec = "UPDATE tblCapRec SET InGDB = " & cbInGDB.Value & " Where ....

[brendalisalowe]

.Value doesn't work and neither does this:

" & cnInGDB.Checked & "

What else can I do?

        Update_tblCapRec = "UPDATE tblCapRec SET InGDB = " & cbInGDB.Checked & " WHERE CaseNumber='" & txtCaseNum.Text & "'AND PartNumber ='" & txtPartNum.Text & "'"

What other things could it be?

.CheckState???

HELP! Thanks!

[brendalisalowe]

.CheckState works perfect! Thanks!

[brucevde]

Do you understand why CheckState works but not Checked.

Or do you even care?

[brendalisalowe]

I think one equals a value of 1 or 0 and the other True or False. Is that right? That is what it said when I was debugging.