Using multiple tables as data sources in forms

[MJD]

Hi,

Having created a form in ms access using a single table as its data
source, is there a way of adding a new text box whose data source
comes from a different table in the database? I know it is possible
to do when you initially create the form, but I have just spent ages
lovingly formatting my form, and I don't want to have to start all
over again!

Thanks!

[PaulT]

Re: Using multiple tables as data sources in forms

As long as all the field naming is the same, you can make a query
based on the original table, and add then join the other table's field
to the query (hope it relates!!)... then change the record source to
be this new query. Then you can add that other text field from the
query's 'list of fields'.

-Paul T.
P.S. (you MAY have go back and set the record source for each field
back to what it had before -- but if the name is the same I think
it'll keep. I'm not 100% sure on this, for I haven't had to do what
you need for a long time).


m.j.diamand@bri ghton.ac.uk (MJD) wrote in message news:<40423b2c. 0402040201.3530 84eb@posting.go ogle.com>...[color=blue]
> Hi,
>
> Having created a form in ms access using a single table as its data
> source, is there a way of adding a new text box whose data source
> comes from a different table in the database? I know it is possible
> to do when you initially create the form, but I have just spent ages
> lovingly formatting my form, and I don't want to have to start all
> over again!
>
> Thanks![/color]