Form displaying multiple tables

[Dusp]

I have a combo box with a list of names in, and a table for each of those people.

When one of these names is selected, i want the contents of the corresponding table to display in a form. Easy Enough.

But...how do I get these tables displaying in one form depending on which name is selected, to save me having 7 copies of the same form just with different sources. All the field names are the same.

One solution I thought of is to put all the data in one table, but would really rather keep it separate.

TIA

 

[neileg]

One solution I thought of is to put all the data in one table, but would really rather keep it separate.

But that is the right answer.

Why do you want to keep it separate? If there is a really good reason (which I doubt!) use a union query to join the tables together.

 

[Dusp]

thanks for your reply.

All my data is now in one table

So my next question is when I run queries on this data, different queries to search through different columns, how do I manage to get all the queries to output to the same form?
Only one query will be run at a time, the form would then be closed and a different query run.

Is this possible?