I think your question suggests you have lots of tables with the same fields,
and you want to be able to use one form to access them all?
If so, it is possible to reassign the RecordSource property of the form to
whichever table you want.
However, a much better idea will be to combine the tables into one. Just add
an extra field, and use that to distinguish whatever it is that currently
caused you to use separate tables. For example, if you have a table for ABC
Company's orders, another table for XYZ Company's orders and so on, use just
one table for all orders and add a CompanyID field so you know who had which
order. This will enhance the querability of your data beyond what you might
imagine, and it also makes it very easy to add new customers without needing
to create more tables.
