It depends on your data of the check box.
So you need to check first the values in SQL server, then you need to select 
you values either as 0 or 1 (0 or -1 that will depends on the type of the 
data).
Integer, char, binary or bit all will have different values for check or 
empty.

Thank you
Omar Al Hathaf


>From: "Ali" <aalshams@h...>
>Reply-To: "sql language" <sql_language@p...>
>To: "sql language" <sql_language@p...>
>Subject: [sql_language] Hey Gurus need help
>Date: Tue, 10 Oct 2000 01:45:46 +0100
>
>I want to SELECT data based on a check box!
>
>I am using it in ACCESS 2000 with SQL command.
>
>Private Sub OnClick()
>
>If Car_Check = Ture THEN
>   SELECT [CAR].[CAR_NAME]
>END IF
>
>What am I doing worng!! I boughtWROX book Prof. ACCESS2k Prog.
>Did see it there?
>
>Thanks
>Ali (email) aalshams@h...
>