472,145 Members | 1,474 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

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 1532
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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.