compare macro

  • Thread starter Thread starter brad
  • Start date Start date
B

brad

i'm looking for the syntax for the condition of a macro
that after the first and last name of a person are
entered on a form that it checks the other first and last
names in the table and if there are any exact matches
triggers a msg box. any help would be appreciated. thanks
 
Bred,

Try this Condition of your MsgBox action...
DCount("*","YourTable","[FirstName]='" & [FirstName] & "' And
[LastName]='" & [LastName] & "'")>0
 
Back
Top