message box

[Osyris]

hi all
need help plz

i need a macro or a code or a querry that when i click on the button (the
one that will run the macro or the code) to compare two fields.
if table1.field1=table2.field2 then a massage will appear that says
Attention!!

also appears in a form which field from table2 is the same with table1.

many thanks

 

[Steve Schapel]

Osyris,

How do you know which records in table1 and table2 to compare? Or do
you mean *any* value in table1.field1 matches *any* value in table2.field2?