Filter database to listbox
I'm using VS 2010 professional and the basic programming language. I have an access database which is pretty simple. I have 1 table named Cards which have 4 feilds Question, Answer, Topic, and Source. I've got two other table which hold the lookup values for Topic and Source.
On the Form I've got 2 bound listboxes for Topic and Source. I want to populate a third list box with the Question and Answer based on the records in table cards who's Topic and Source feilds match the selected items in the other 2 listboxes.
Re: Filter database to listbox
You could use the On_Changed() function of each LB. Just modify a .Filter() command whenever one changes. That way you can bind table to the results, and filter out what the user selects
Re: Filter database to listbox
It's really the code that I need help with.
Re: Filter database to listbox
Take a look at the samples, here