seek or find method

[si_the_geek]

If the two tables are linked in some way, why not join them in your recordset (or whatever it is you are using)?

You can load the data like this:

SELECT table1.*, table2.*
FROM table1
INNER JOIN table2 ON table1.Cope = table2.Cope

.and if you only want a specific value of Cope, specify that in a Where clause:

SELECT table1.*, table2.*
FROM table1
INNER JOIN table2 ON table1.Cope = table2.Cope
WHERE table1.Cope = 3