Results 1 to 4 of 4

Thread: Two Datagrids on a single Adodc

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jul 2000
    Posts
    30
    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!!!
    Matt

  2. #2

    Thread Starter
    Junior Member
    Join Date
    Jul 2000
    Posts
    30
    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?
    Matt

  3. #3
    Fanatic Member
    Join Date
    Oct 2000
    Location
    London
    Posts
    1,008
    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...

  4. #4

    Thread Starter
    Junior Member
    Join Date
    Jul 2000
    Posts
    30
    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...
    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width