ADO recordset position and datacombo ctrl. 
Author Message
 ADO recordset position and datacombo ctrl.

Hello,

How do I get the ado recordset position to move with a bound control ie
dataList, dataCombo
I have bound an ADO control to a table in sql7.
I have set a dataCombo control's  properties [Bound Column], [List Field],
[Data Field] to a column in  my table.  Set the row source and data source
to my ado control.  The ado ctrl opens a recordset with an SQL statement
(one table only).

The fields show up in the datacombo control.  When I change items in the
data combo control I expect adodc.recordset to change it's position but It
doesn't.  How can I make this happen?
In the past I was able to do this using DAO and a DBcombo box.  Selecting
one record in the other would always reposition the current record in the
other control.  Can this still be done with ADO and data controls?

Any help appreciated
Thanks
Hiram



Fri, 12 Mar 2004 21:39:46 GMT  
 ADO recordset position and datacombo ctrl.
Try this:

rs.bookmark = datalist.selecteditem

Eric

Quote:
> Hello,

> How do I get the ado recordset position to move with a bound control ie
> dataList, dataCombo
> I have bound an ADO control to a table in sql7.
> I have set a dataCombo control's  properties [Bound Column], [List Field],
> [Data Field] to a column in  my table.  Set the row source and data source
> to my ado control.  The ado ctrl opens a recordset with an SQL statement
> (one table only).

> The fields show up in the datacombo control.  When I change items in the
> data combo control I expect adodc.recordset to change it's position but It
> doesn't.  How can I make this happen?
> In the past I was able to do this using DAO and a DBcombo box.  Selecting
> one record in the other would always reposition the current record in the
> other control.  Can this still be done with ADO and data controls?

> Any help appreciated
> Thanks
> Hiram



Sat, 13 Mar 2004 01:32:49 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. recordset record position change upon the Datacombo change...

2. recordset record position change upon the Datacombo change...

3. recordset record position change upon the Datacombo change...

4. Navigating through Recordsets using DataCombo (ADO)

5. ADO Recordsets and DataCombos

6. Navigating through Recordsets using DataCombo (ADO)

7. DataCombo box using ADO recordset

8. ADO DataCombo Bind to a Recordset.

9. Populating a DataCombo Box with ADO RecordSet

10. Positioning to a record in an ADO recordset

11. Open ADO recordset on another ADO recordset - possible?

12. How can I position the current record with the DataCombo Control

 

 
Powered by phpBB® Forum Software