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