Best Way to Search Multiple Criteria

[Elvis72]

I have in the past created forms that had 2 search boxes that popped up for searching like this:

Enter First Criteria:
Refinery

Enter Second Criteria:
Saudi Arabia

At the moment I have a Find as You Type Form that works fine, but I need to be able to narrow results with multiple criteria like this:

Criteria 1:
Ethylene
Criteria 2:
15 (yrs of experience)
Criteria 3:
Crude
Criteria 4:
Sulphur
Criteria5
Cracker

I would ideally like for it to function the way the Find as you Type Form does as they can see the list as it is shortened and decide when they want to stop or where they need to go back to.

Your help is GREATLY appreciated!~

 

[kjv1611]

Well, here's an idea, assuming you're not already doing it.

Have a subform show a query. Everytime one of the search boxes are updated, have the query update and refresh based on that criteria.... Depending on how complex your situation is, it could be very complex or not to bad... it could need to be done in VBA, using SQL to edit the query, or either just run a SQL query, create/edit/update a table based on the search critiera... and that table (not query) would then be the record source for the subform..

--

"If to err is human, then I must be some kind of human!" -Me