autoforms problem

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 Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ecc28" <anonymous@discussions.microsoft.com> wrote in message
news:10fc701c44139$93122e00$a301280a@phx.gbl...
> please help to advise how to create standalone form from
> many tables in access seperately.
>
> Thanks.

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.


>-----Original Message-----
>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 Browne - Microsoft MVP. Perth, Western Australia.
>Tips for Access users - http://allenbrowne.com/tips.html
>Reply to group, rather than allenbrowne at mvps dot org.
>
>"ecc28" <anonymous@discussions.microsoft.com> wrote in
message
>news:10fc701c44139$93122e00$a301280a@phx.gbl...
>> please help to advise how to create standalone form from
>> many tables in access seperately.
>>
>> Thanks.
>
>
>.
>

ecc,

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

Regards,
Dan

"ecc28" <anonymous@discussions.microsoft.com> wrote in message
news:10fc701c44139$93122e00$a301280a@phx.gbl...
> please help to advise how to create standalone form from
> many tables in access seperately.
>
> Thanks.