Hi Roland,
One idea is to use DataViews and use the RowFilter property to set new criteria for the filtering of the data in combobox2.
>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
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi