databound combobox.text being overwritten
Posted on 2009-02-10
In summary my problems is,
Updating/populating a comboboxes' data bound items results in the first item of the resulting databound list being displayed in the combobox, overwriting the existing displayed value.
I have a simple data form which has several textboxes that are all bound to an sql table (DATATABLE). On this form I also have a combobox, it to has its text control bound to DATATABLE. The combobox uses data bound items in its drop down list. These items are from a seperate sql table (LOOKUPTABLE).
The records that are loaded into LOOKUPTABLE are dynamic and are the result of a query which uses other values currently being displayed in the textboxes on the dataform.
My problem is that when the LOOKUPTABLE has its items updated/populated, the value currently displayed in the combobox is overwritten with the first value in the data bound list.
Hope this makes sense.
Thanks in advance for any help.