VBA - Searching forms for most common name

[daoxx]

Hi

I'm using MS Access 2002 / VBA 6.
I've a database with several tables / forms, and some code. Everything is working fine.

I have 2 fields in each form. Each of these fields contain names from employees.

What I need to find among all these form's 2 fields, is the most common name (the one that appears the most) in both 2 fields together.
Some of the fields may be empty.
I need to perform this with a button, and I would also like that the search would be made in ALL forms, which means that by clicking the button only one name would come as output (msgbox maybe).

Structure Example:
Form1 Form2 Form3
name1 name1 name1
name2 name2 name2


Data Example:
Form1 Form2 Form3
Anthony Tom
Tom Andrew

Out of the example above, Tom would come as output.

Please Help
Access / VB Newbie

Thanks

[missinglinq]

Your forms are really irrevelent for this sort of search. Forms don't store/hold data, they merely display it.What is relevent are your tables.

Welcome to TheScripts!

Linq ;0)>

[daoxx]

Your forms are really irrevelent for this sort of search. Forms don't store/hold data, they merely display it.What is relevent are your tables.

Welcome to TheScripts!

Linq ;0)>

Thanks for your response :)

Even if forms aren't relevant for the search, I think you can still get what I need here. I would appreciate if anyone could direct me in a way I could solve this, as I can NOT do it due to my low expertise.
Otherwise, I'll keep searching for the rest of the day.

Thanks

Note: Form1 -> Table1, Form2 -> Table2, Form3 -> Table3

[daoxx]

Maybe I do not need VBA? Only queries?

Please help.