country to state dependency drop down box?..

[ticc888]

HI,

I'm new to VB and struggling to find code that will assist o build or start me off building the traditional dropdown box dependent on another ....

justlike selecting the country, which based on the countrywill filter the next drop down to the states relevant to that country?

Can anyone assist?

Thanks in advance, great forum, great vibes..

Frank

ticc888@yahoo.com

 

[ChrisUK]

Why use VB ?

Two drop down boxes on your form, the first one selects everything from a table in your DB - lets say contries

The second box links to a second table in your DB - lets say States. You would need to set the row source to select * from States where CountryName = listbox1.value

I've not tried this before but I see no reason why it wont work, it's a good starter for 10 anyway!

HTH

ChrisUK