The DataView is a view of a DataTable. The view can be filtered and sorted. DataViews can be bound to controls and give you more control then using a DataTable because of the filtering capability. You will need to change your binding of the combobox to use the DataView instead.

>Hi Cathi,
>
>My bindings are to my dataset so that the grid gets updated from the comboboxes and textboxes. I take it that the dataset does not allow or have a sub filter; only the select has a filter.
>
>Once the dataset for a table is filled then you cannot have a sub filter to filter the dataset table? Correct? Poor English I know.
>
>If I use a dataview will I have to change my existing bindings?
>
>I had a heck of a time getting the comboboxes to work correctly with the bindings of textboxes and comboboxes and the grid so that everything was updated properly.
>
>What do you think?
>
>Thanks
>Roland
>==========================================================================
>
>
>=========================================================================
>
>>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