binding data combo to recordset 
Author Message
 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



Sat, 17 Dec 2005 22:44:20 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Data bound Combos or Not Data Bound Combos

2. Data Bound Combo Box within a Data Bound Grid

3. Binding data combo, datagrid, ... with DISCONNECTED Recordset

4. Binding data combo, datagrid, ... with DISCONNECTED Recordset

5. Combo Box like Data Bound Combo Box?

6. Data designer bound controls seem to lose their binding to the recordset with Requery

7. Data designer bound controls seem to lose their binding to the recordset with Requery

8. Problems refreshing data from Data bound Combo Box

9. Data-bound Masked Edit makes all data-bound controls not display data

10. Combo box bound to ADO recordset object?

11. Combo box bound to ADO Recordset object?

12. Binding a recordset to a databound combo ??

 

 
Powered by phpBB® Forum Software