method seek or find

[sal21]

I dont know if is correct to post here....

admint i have MYmdb.mdb
in internal of this database have myatbel1 and mytable2
in the same table have a field named COPE

now...

from other vba macro (in excel using ADO) i fill MyVar with value.

is possible to find in the 2 table and into filed COPE if existis the value assumed MyVar and is existis go to the next line of code

similar:

seek Myvar in rds1 in filed COPE
existis ok
goto next line
not existis
seek MyVar in rds2 in filed COPE
existis ok
goto next line

hope undesrtand me...

but, naturally other way are welcome...