Where you are giving the user lots of search options, the most efficient way
is to build the SQL statement dynamically. You can build just the WHERE
clause and use it as the Filter for a form, or the WhereCondition for an
OpenReport action.

This example shows how to loop through check boxes named chk1, chk2 etc, and
build up the WhereCondition string to open a report, based on a numeric
field named ProductID. If none of the boxes are checked, then all products
are returned. If one or more boxes are checked, only those product(s) are
returned:
Dim strWhere As String
Dim lngLen As Long
If Me.chk1.Value Then
strWhere = strWhere & "1, "
End If
If Me.chk2.Value Then
strWhere = strWhere & "2, "
End If
'etc for other check boxes.
lngLen = Len(strWhere) - 2 'Without trailing comma and space.
If lngLen 0 Then
strWhere = "(ProductID IN (" & Left$(strWhere, lngLen) & "))"
End If
DoCmd.OpenReport "Report1", acViewPreview, , strWhere

One disadvantage of the check boxes is that you have to redesign your form
every time you add another product to the database. You could avoid that by
using an unbound multi-select list box. For details, see:
Use a multi-select list box to filter a report
at:
http://allenbrowne.com/ser-50.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Leslie" wrote in message
...
I have 8 products chosen by checkbox in a search form, they check the box
to
retreive all the items entered for a specific product or products, they
should be able to choose more than one product, i.e. I want product 1 and
product 4, but need to be able to choose up to all 8. There are multiple
search criteria on the form. I have all the other searches working, but
the
checkboxes. These boxes are checked when the data is entered into the
table
via a new product change form. I'm using checkboxes because of the large
number of cretiera that could be possible and even our own people can
spell a
product name differently making it impossible to search and get all the
information on specific product(s).