Filtering combo boxes from Access database

[mtrsoft]

Hey guys,

Ive searched the forums for this answer but came up with nothing....So I have this form that has these combo boxes and text boxes...And when you choose an item from the combo box, it filters out and the results come up on the other text boxes....I am wondering how I can do this ( a code of some sort ) if I have my VB linked with a database from Access....

The screen shot is down below.


Thank you in advance.

[Dewwd]

Assuming you are using an access database, the most common way I suppose would be to use SQL commands to select what you want...
I don't know what your databases look like, but I'd so something like this...


SELECT * FROM Player WHERE CountryName = ? AND Event = ?


Its hard to say tho because I don't know what your database or tables etc look like =) Anyways hope that helps!

[mtrsoft]

Thanx for the reply dewwd...

Ok so this is a screen shot of the database to further help...Ummm...I got the code you suggested ( Thanx! ) and it works but only one time, the next time we run the filter it gives an error....

What to do

[Dewwd]

What error does it give you?

If you want to email me your code I'll be more than happy to look through it and post notes and send it back to you...

my email is [email protected]