Checking data in one table against another table

[Guest]

I'm trying to figure out how to write code that will check data in one table
against data in another table.

I've tried using the following code but no luck:
Dim mydb as Database
Dim mytable1 as Recordset, mytable2 as Recordset

Set mydb as CurrentDb
Set mytable1 = table name
Set mytable = table name


Any help would be greatly appreciated

 

[theonesteve]

Tom,

The code you posted does nothing but set a couple of Recordset objects
to the same table name.

If you want to compare the data in two tables by returning only records
that have the same data in the same fields, use a query and join every
field in table1 to its mate in table2. This will return only records
that are the same in both tables.