seek or find method

i have a connection on MyMdb.mdb with table1 and table2
each table have a filde named COPE
is possible to use the seek method or find method (i dont know wat is the best) simultanious on the 2 table in filed COPE????

or... seek first on table1 and after seek on table2...

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:

Code:

---

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:

Code:

---

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

---