Filter Search

[chad101]

I want to add a filter search on my forum which will look up load numbers based on the selection from 3 other combo boxes. I already have two combo boxes; Customer & Load. When the user selects a customer the Load combo box grabs all load numbers from the database with this customer name. I would like to add two more filters, Part Number, and Date. The only problem is I don’t know how to set my load combo box to only select values based on the other 3 combo boxes (Date, Customer, and Part #). To clarify my question, please take a look at my database example.

 

[chad101]

note

Note: When database is opened it auto hides the access program. When opening the database hold down Shift

 

[cbialzik]

I'm looking to do the same thing you are. I just found this post and it has a link that I'm looking at now. I think this will help you as well.
http://www.access-programmers.co.uk/forums/showthread.php?t=103194&highlight=combo+boxes