Combobox databinding issue

[Guest]

I have a dropdown style combobox that shows the list of active users. It is
bound to datatable with two columns (UserID and UserName). I display data
entry form where value for "Contact" field is supposed to be selected from
this combo. As an example, I select userA in the combo and save a record.
After some time userA is made inactive in the system. Here comes the problem.
Combo's dropdown list will not have userA, as it shows only active users.
When I try to display the old record with userA as a "Contact" on the data
entry screen, combo is automatically defaulted to the first item in the
dropdown list, for example userB. To system user it looks like "Contact" is
userB, which is wrong.
Does anyone know how to overcome this problem?

 

[Cor Ligthert]

Irina,

When I really understand you than an answer can be (there are a lot) to add
the information from the contact to the combobox when it is not in that, set
a switch and remove it when the update is done.

Just a thought,

Cor