Would anyone be able to tell me if it is possible to search 14 different tables at the same time using a seach criteria such as "name" from a form being used as a main page which is usually used to open forms related to the 14 tables
You would need either 14 separate queries, or a UNION query stringing
all fourteen tables together.
You may want to check your database design! In a properly normalized
set of tables, each "entity" relevant to the database has a single
table; one would not normally need to search multiple tables to find
an individual, since all individuals of a given "entity class" would
be stored in a single table. How do these tables differ? If they all
contain (say) people, just different groups of people, might you not
do better to have *one* table of People, with an additional field
identifying which group they are in?
