Hi,

Windows Form vb.net SqlConnection, SqlDataAdapter and Dataset contains 4 tables.

How do you filter a combobox when it receives focus so that it would display the items based upon the value of a previous combobox or field?

1st combobox1 "type field"

2nd combobox2 "subtype field"

The results (items) displayed in the combobox2 would depend upon the value of 1st field. SOMETHING LIKE THIS Filter (type = "Apple")

The comboxbox2 would display the colors of an apple; Red, Green, Yellow instead of all the colors Red, Green, Purple, Orange, Yellow.

Thanks
Roland