How can I search multiple tables?

[botts121]

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

[RuralGuy]

Just create a Public Function in a standard module that does the work for you. Your question suggests you may have a normalization issue as well.

[botts121]

how do I go about adding that public function to the module? and what do you mean by normalization?

Thanks,

Matt

[RuralGuy]

We'll start with normalization. Here's an article from Microsoft on the subject. Google knows where there are tons more. As for a Global Function, have you ever written any VBA code? I use DAO for a table reference library. What do you use? What are the exact names of the tables?

[alcoool]

or you ca design a query for every table and display them in a form