IIF to check values in more than one table

[KarenF]

Hi,

I want to put a control onto a form that will tell me if a record has a
matching record in another table. I know I can use a query, the unmatched
query wizard (to see which records don't), and the find duplicates query
wizard (will tell me which records are duplicated in a table on a given
field), however, I would like the control to simply give me a yes or no
answer when comparing the ID of the current record to the Record IDs in a
matching table.

Any ideas?

Many thanks,

Karen

 

[Allen Browne]

Use DLookup() to see if the value exists in the other table.

Basics of how to use this:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html