-
Nov 17th, 2000, 03:32 PM
#1
Thread Starter
Junior Member
Hey all,
I'd like my users to be able to click on a record in one Datagrid, and have it display a different recordset in the second Datagrid using a query based on one of the fields in the record.
I tried doing this with two Adodc's, but when I put the app on other people's machines, I got an Adodc error, which I'm assuming is because I have multiple Adodc's connected to the same database. If I'm right (tell me if I'm not!) then I have to do this with one Adodc. How can I do this and still keep the original data in the first Datagrid?
Basically, I need to populate a Datagrid, disconnect from the Adodc it's attached to, and then "freeze" it's contents so I can use the Adodc to populate the second grid.
Whew!!!
-
Nov 20th, 2000, 08:30 AM
#2
Thread Starter
Junior Member
Put another way, is there any reason why I wouldn't be able to have more than one Adodc on a form connected to the same database?
-
Nov 20th, 2000, 11:08 AM
#3
Fanatic Member
You certainly can use more than one ADODC, however, if you are accessing the same table you might get problems. Can you possibly post the code that is giving an error?
P.
Not nearly so tired now...
Haven't been around much so be gentle...
-
Nov 20th, 2000, 12:21 PM
#4
Thread Starter
Junior Member
Thanks for the reply Paul. I figured out the problem, it wasn't so much the double Adodc's, I wasn't installing the Jet 3.51 drivers correctly on the users machines. All better now...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|