By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,525 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Using multiple tables as data sources in forms

P: n/a
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!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.*********@brighton.ac.uk (MJD) wrote in message news:<40**************************@posting.google. com>...
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!

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.