Record source selector...

[postman]

How to?
At the moment I have 6 linked tables that have data I need to search &
extract from. To do the searching I have 6 'types' of queries & forms to
each tables record eg: 6 select queries, 6 append queries, 6 delete queries,
6 delete duplicates queries, 6 forms, 6 subforms..etc etc.
I would like to have just one all purpose query 'type' and form/subform to
do all this repetetive work from.
The 6 linked tables have the same field names just different records.
Can I change the record source of the queries through a combobox on a form,
thus eliminating the need for 6 of everything, so I would have just one type
of query and form, I can then select the record source ( the linked table
names) through the combobox.
It's a bit beyond my comprehension at this stage, could someone steer me in
the right direction.
So for I have created a table with one field; typed in the list of the
linked table names, for the combo box to use as the record source selector.
How do I use that in the query as the record source...

Thanks.

 

[Dale Fye]

If the tables are identical, it implies that there is something different
about each table (year, location, etc). Your best bet is to identify this
one thing that is different and add a field to the tables that describes
this one thing. Then, combine all 6 tables into a single table, and then
delete all of the extra forms, queries, etc. You may have to add a combo
box to your form to filter the records on the field that you added, but this
sure beats having 6 forms that are "identical" in structure.

HTH
Dale