
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