If FieldName(s) (multiple) = Multiple FieldNames from 2 Tables Then "Error"

[pianoprodigy]

Ok, I have a form where new clients are entered into the system. We would like to have an automated check that could be run which would check several different fields and compare them to several different existing fields in two different tables to see if the same name shows up. What is the easiest way to go about doing something like this?

Thanks.

 

[KenHigg]

Use the dlookup() function?