InfoPath Dev

Hi, I'm new here, I did not have the change to read all answers yet, excuse me for being newbee. (excuse my English)

Question:

I have a Access 2000 database .mdb. A primary dataconnection is to filled in on a infopath form, it works. To check the info, which already was put into the DB, I filtered the Data by using multple dropdown boxes, untill there's only one integer left, say CarID.

In another table there is some finance-info over the selected car, using the filtered method of infopath, all finance-data (6000 records) is downloaded into infopath, then filtered. I want to download only the access data regarding to the selected CarID (10 records). It should get a better performance.

I hope that I explaned enough the problem, best regards, howie

Hi, Welcome on board!
If you can write here is the code sample to change the query on the run
ADOAdapter2 adoAdapter2 = (ADOAdapter2)thisXDocument.DataAdapters["Connection Name"];
adoAdapter2 .Command = queryString;//Write your query here
adoAdapter2 .Query();