autoforms problem

  • Thread starter Thread starter ecc28
  • Start date Start date
E

ecc28

please help to advise how to create standalone form from
many tables in access seperately.

Thanks.
 
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.
 
Allen,

Thanks for your reply.

It seems not to solve my problem as there are many
standalone tables with different formats that should be
created to standalone tabular forms too.
 
ecc,

Not sure what you want, but have you tried using the form wizard on each an
everyone of your tables?

Regards,
Dan
 
Back
Top