Conditional Expression when running Macro

[ITbeast]

Hello,

Does anyone have a way I can halt a Macro if it determines that records in one table already exist in another table. I have been introduced to conditional expressions, but I'm not sure exactly how it works.

Pretty much, I want to check the formid field in the dump_table and check it against the formid in the house_table and if there are any matches, I don't want the macro to do anything besides give a cryptic error message.

 

[mp9]

So your condition would check if a DLookup(...)=0 then...?

http://www22.brinkster.com/accessory/