check Box

[Guest]

I have a set of 4 Check Boxes Called ChkComp, ChkYB, ChkCanceled, and ChkAll
The user should be able to check more then one. I have another set of
check box for years and i tried to use that same code for this and its not
working. Is their any other way that works.

thanks


If Not ChkALL Then

strAdtype = ""

If ChkComp Then
strAdtype = strAdtype & "'Comp', "
End If

If ChkYB Then
strAdtype = strAdtype & "'YB', "
End If

If ChkCanceled Then
strAdtype = strAdtype & "'Canceled', "
End If

If Len(strAdtype) > 0 Then
strAdtype = " IN (" & Left$(strAdtype, Len(strAdtype) - 2) & ")"
End If

End If

 

[Ron2006]

And doesn't work means ????????????

 

[Ron2006]

And you have this piece of code where ?????????????????