I have multiple combo boxes... need help

[mtrack81]

Ok, I have 5 combo boxes on a form, each with no less than 10 choices.... What I want to do is look in a certain table and ONLY pick out the record(s) that have all five of the choices in common. So as you can see, I am really trying to get a small number of records here on a form. I also have a "Proceed" command button where once the user is done picking their choices, he/she will click on "proceed". I want to run an event procedure on the "on click" event, but I don't know where to go with this.. any help is appreciated...

[makai]

I can think of a nested SQL statement - however I haven't seen one 5 deep before

or perhaps just AND your conditions in the WHERE part of the SQL

example of nesting at:
http://pages.about.com/vbmakai/dao4.htm