Checkbox to signify what to search for

S

Sara M

I am attempting to create a form that will be used to launch a search in a
table in access. Here is where I am stumped...

1) How do you make a form look at anything checked or selected in a
combo/list box and search the table for any records that match all of the
information specified?

2)If, let's say, 4 out of the 5 fields need to be searched, how do I tell it
not to search for information in the 1 field that is not pertinent?
 
Top