check Box

[dbpatadia]

on this form, i have 6 check boxes years from 2007-2003, and ALL years. the
users should be able to check more then one when they are trying to filter on
years. The field just contains year in the main table.

when i click on apply filter whatever year i have checked it should appear
on the subform. Example of the code below. the code i have just lets me
filter one at a time. if i check 2003 and 2004 it doesnt work.


stryear = ""
If Chk2003 Then
stryear = "like " & 2003
End If

If Chk2004 Then
stryear = "like " & 2004
End If

ifchk2005 then
stryear = "like" & 2005
end if

I have the same for the other years