Check whether records exist in Access table

[elbatz]

Can somebody help me? How do I know if records in Table1 are also in Table2, using VB6 code?

For example:

If Table1 has 1111 in column1 and also Table2 has 1111 in column2
msgox "Existing record in Table2"
else
msgbox "No record in Table2"

[debasisdas]

you need to pass the value of table1 and check the same in table2 using COUNT().

if count returns more than 0 then the data exists else does not exist.