IIF to check values in more than one table

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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"KarenF" wrote in message
...

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.