searching database for records based on certain multiple criteria

  • Thread starter Thread starter Shannan Casteel via AccessMonster.com
  • Start date Start date
S

Shannan Casteel via AccessMonster.com

I have a data input form that has several fields. Some of the fields are
combo boxes. One particular combo box limits a number of check boxes that
are displayed. I need a search form that looks very similar to the data
input form. The user should be able to input as many fields as he or she
wants and then press a search button. Hopefully, then the first matching
record would be shown.

The combo box is a ProblemCategory and the check boxes are
ProblemSubcategories. The combo box is one field in the main table, and each
check box is a seperate field in the main table.

Just to make it a little easier to understand let's say the user has selected
Fuel in the ProblemCategory combo box and 2 check boxes (Fuel Line and Fuel
Pump) that coorespond to the ProblemCategory. After pressing the SEARCH
button the user should be taken to the first record that also has these
matching fields.

Any suggestions would be greatly appreciated...I think I'm almost done with
this thing. Thanks for your time.

Shannan
 
In the Click event of the button that initiates the search, build a query to
find the record you want. Or, you could build the where part of a Dlookup.
You would have to look at each check box to see if it is to be included and
if so, add the criteria to the statement.
 
Back
Top