469,126 Members | 1,292 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,126 developers. It's quick & easy.

Adodc Link

104 100+
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.

Apr 6 '09 #1
2 1427
104 100+
Just realised how easy it is, used a command button to move records back and forth
Apr 6 '09 #2
Use following codes to navigate both controls :
For Next Record
Expand|Select|Wrap|Line Numbers
  1. Adodc1.Recordset.MoveNext
  2. Adodc2.Recordset.MoveNext
For Previous Record
Expand|Select|Wrap|Line Numbers
  1. Adodc1.Recordset.MovePrevious
  2. Adodc2.Recordset.MovePrevious
For First Record
Expand|Select|Wrap|Line Numbers
  1. Adodc1.Recordset.MoveFirst
  2. Adodc2.Recordset.MoveFirst
and so on..

Apr 6 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Raoul Watson | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.