Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Two Data Controls

Status
Not open for further replies.

toolsofministry

Programmer
Sep 11, 2002
24
US
I have two data controls on one form. I want the second DC to advace when I advance DC one.

I have tables in DC two that I use to populate fields in CD one. When I come back and scroll through DC one I want the matching record from DC two to display the appropriate fields.

Thanks
 
1. Use a primary or uniquec one to do a search in DC2.
Or,
2. if both DCs use identical recordsets, then set the DataSource of DC2 to a cloned recordset of DC1 and set the bookmark of DC2 to that of DC1.
Or,
3. If #2 applies, the create a single Recordset object and set the DataSources of both DCs to the Recordset Object - when DC1 moves to another record, DC2 will move also. [/b][/i][/u]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top