Hi guys,

I'm having a form in which the user can check a checkbox.

Depending on the value (checked or not) an sql string must be constructed which looks in an access 2000 database to find items (tblCD_detail.Active) who have a corresponding value.

I tried the following code to detect the state of the checkbox in the form:

If Me.CheckBoxActive.CheckState.Checked = CheckState.Checked Then
strSQLzoeken = strSQLzoeken & " and tblCD_detail.Active= true"
Else
strSQLzoeken = strSQLzoeken & " and tblCD_detail.Active= false"
End If

I don't get building errors but the code doesn't work properly because I dont get the expected results.

I think it has something to do with the code or the way I talk to the values in the database.

Can somebody help me?

Thanks

Tom