
binding data combo to recordset
Hello,
I'm having a problem updating the combobox value in
a recordset. The box is loading ok with the list values
but the backend database is not been updated, all the
other text fields are been updated ok so it is not a
problem with the recordset.
This is what I have:
I have a main adodc called DatCustomerrs for which every
field on the the Customer form is bound quite happily.
I have another adodc called datCustomerType that contains
the look-up values for the customer types. I don't want to
update this.
I have a data combo called CustomerTypeCombo with the
following values.
bound column : CustomerTypeKey from datCustomerType(look-
up)
data field : CustomerTypeIndex from datCustomerRS
data source : datcustomerrs - the main adodc
List field : CustomerType - from DatcustomerType
RowSource : DatCustomerType - look -up adodc
On clicking save and close after changing the customer type
I have the following code
DatCustomerRS.Recordset.UpdateBatch adAffectAll
This changes all the fields that I have changed apart from
the data combo field.
Any ideas anyone, thanx in advance
Geraldine