How can I search a database on multiple criteria selected from listboxes?
I am new to VB and I am finding it difficult to understand. I am using Visual Studio 2005.
I want to search a database for several items, I am using the My Movie Collection template to practice with and I want to be able to search for actors, directors and release dates and see the movies that match.
I want to use listboxes for the items to search on and populate them with the possible options from the database. Ideally I would like the results to be updated as I click on the options in the listboxes (no 'search' button). I want to be able to click on more than one item in a listbox (e.g. several dates) and I want to be able to deselect items that I previously clicked on.
I have found examples of searching for one thing in a database but I cannot find any examples of how to search for multiple items or how to use listboxes to do the search. I have spent ages looking for a solution and I am getting really confused about what I need to do.
L.
