Pls Suggest Me......

hi

i am using html checkboxes to let user to select categories in which search has to be done. there are  4 checkboxes for 4 categories.

this query i have checked in query anakyzer. this query is working and displaying results.acc to this query user has selected "3 checkboxes" and entered "airports" to search.

SELECT * FROM tbl_Arab_Newsletter WHERE (Month(month) = '2' AND year(month) = '2008') and (cat_number = 1 or cat_number = 2 or cat_number = 3) and (story like '%airports%' )

i have written code like this.

strSQL = "SELECT * FROM tbl_Arab_Newsletter WHERE (Month(month) = '"& m &"' AND year(month) = '"& y &"')"strSQL = strSQL & " and cat_number = 1"

end if

if cat2="on" then 'check box 2 is enabled means this conditionstrSQL = strSQL & " and cat_number = 2"

end if

if cat3="on" then 'check box 3 is enabled means this conditionstrSQL = strSQL & " and cat_number = 3"

end if

if cat4="on" then 'check box 4 is enabled means this conditionstrSQL = strSQL & " and cat_number = 4"

end if

strSQL = strSQL & " and (story like '%" & search & "%')"

but this statements are not working. how to write the if conditon  acc to the query. pls help and if dont mind pls give me the correct code.

thank u.