Ive got a form with three combo boxes, cmbBox1, cmbBox2, cmbBox3 and one listbox, lstView. I have a list of items being added to the listbox from another source, looking like:
Frank A 1
George A 1
Walter B 2
Betty A 3
Sam B 3
In cmbBox1 I have the names Frank, George, etc...
In cmbBox2 I have the group A, B, C, etc....
In cmbBox3 I have the numbers 1, 2, 3, etc....
I want to filter whats showing in the listbox by what I have chosen
from the 3 combo boxes. And I plan to put a blank entry in each
combo box, in case I wanted to just search for a Name and Group and
not the Number or any of the other scenarios. How would I do this? Source very appreciated!
(Im not using a datasource or database to pull in the
information into the listbox. Thats already taken care of.)