>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...
It is true that Find only work with one field (but you can concatenate fields in your recordset).
Seek is not universally supported. Read this:
http://www.able-consulting.com/ADO_Faq.htm#Q23Joe gave you a great workaround (requery the database using a Where clause).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com