I am developing using visual basic 2005 and have microsoft access serving as a backbone.
I have 3 combo boxes that have various collection items in them and depending on what the user selects the documents that match the word show within the datagridview at the bottom. What I would like to know if it is possible to do this search with and AND condition, meaning that the user will be able to click maybe a checkbox or another control that will let combo boxes know that the user can select item from all 3 combo boxes to pull the result.
So the user will select an item from 1st combo and then 2nd combo and then 3rd combo and then the documents that are stored within the database will be pulled based on this search.
Is there a way to do this at all.
Can someone plase give a link to a tutorial or book that describes how to do this?