Adodc Link

[Wernerh]

Hi, please can anyone tell me if there is a way to navigate two adodc controls. I have a from with adodc1 and adodc2 - each linked to their own mdb table working perfectly. Is there any way by code that if you use the adodc1 control to navigate to the next record it will mirror this action in adodc2.

Would appreciate any insight, not even sure it can be done.

Regards
Werner

[Wernerh]

Just realised how easy it is, used a command button to move records back and forth

[EYE4U]

Use following codes to navigate both controls :
For Next Record

Adodc1.Recordset.MoveNext
Adodc2.Recordset.MoveNext

For Previous Record

Adodc1.Recordset.MovePrevious
Adodc2.Recordset.MovePrevious

For First Record

Adodc1.Recordset.MoveFirst
Adodc2.Recordset.MoveFirst

and so on..

Regards
ARUZ