Filtering combobox items based on user add, view actions

[phillipi]

VS2005/SQL Server 2005 - I have simple a combobox that is data bound to status lookup table. For the OrderEntry screen where the combobox resides, I can easily filter out the invalid statuses by setting theBindingSource.Filter property. However, since that screen is also used for viewing order records, if I set the BingingSource's Filter property and the order changes its status to one that I filtered out, those records will no longer show when the user attempts to retrieve them.

Any design tips or ideas how I can circumvent that problem... please suggest. The only cumbersome workaround I found so far is to show a text field called status, and another status field combobox with a valid set of items in its dropdown list.

Thanks,
Phillip