Unanswered: Problem with Vb and DataCombo control. Please Help!!!
I am using a DataCombo comtrol to modify a field in a table (SQL server).
I setup all the required properties: DataSource, DataField, RowSource, ListField, BoundColumn.
For RowSource, I use a DataControl.
For DataSource, if I use DataControl, it works fine. (the DataSource get update when I change value in the DataCombo.
If I set the DataSource at runtime (Set DataCombo1.DataSource = rst), the DataCombo does NOT update the value in the DataSource. The recordset is open with adOpenStatic and adLockOptimistic.
I try this on two different applications, and same happens.