-
December 7th, 2010, 04:10 PM
#1
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.
-
December 7th, 2010, 04:45 PM
#2
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
-
December 8th, 2010, 08:18 AM
#3
Re: Filter database to listbox
It's really the code that I need help with.
-
December 8th, 2010, 12:34 PM
#4
Re: Filter database to listbox
Take a look at the samples, here
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|