checkbox value: how to detect

[zozzie]

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

[carlblanchard]

try using 0 and 1 instead of true or false

[carlblanchard]

oh with your search forms thing

nice way to deal with it is

formSearch have just a designed form there and when press the find button set the inputted value into a module

ie MyModuleVar = me.txtInput.text

then you just open second form as normal
onload event contains your sql and getting the input from the module var hey presto easy