Two Datagrids on a single Adodc

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!!!

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?

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.

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...