>Is there any way (other than using the 'Filter' method which I think is quite slow) of seeking a set of values from one ADO table in another table? I know that there is the Find method but this only seems to work for finding values in a single field whereas I need to seek on three different fields. This has got me stumped...
I would look into executing SQL commands against the recordsets/tables.
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams
