I have a database that has numerous tables in it. Within each table there are Home Phone # Fields. I want to be able to open a form, search for a phone number that could be in any of those tables and then have it tell me if the phone number exists or not but not display the phone number.
Does anyone have any idea as to how to do this?
Thank you in advance,
Matt