How to link an existing Form to additional Tables

[Burger]

I have entered data in for Table and subsequently I have designed a Form in
Microsoft Access that uses this Table.
Now I have recently constructed a second Table with different data (in the
same Access file). I would like to use this second Table in the form as
well. How can I add the variables from the second Table to the form? At the
moment, only the variables from the first Table are available in the design
view of the Form. (I don't want to integrate the two Tables in one Table.)

Thanks in advance!

 

[John W. Vinson]

I have entered data in for Table and subsequently I have designed a Form in
Microsoft Access that uses this Table.
Now I have recently constructed a second Table with different data (in the
same Access file). I would like to use this second Table in the form as
well. How can I add the variables from the second Table to the form? At the
moment, only the variables from the first Table are available in the design
view of the Form. (I don't want to integrate the two Tables in one Table.)

Thanks in advance!

How are the two tables related, if at all? Are they storing the same kind of
data (same fields)? If so, having the two tables for one kind of information
is generally A Bad Idea.

What you can do to see both sets of data on one form is to use an unbound Form
(no recordsource) with two side-by-side Subforms, one bound to each table...
but I strongly suspect that your table design isn't ideal.

John W. Vinson [MVP]

 

[boblarson]

You can use a subform to put more than one table, or query, on a form. If
the two tables have a related field (one-to-one) then you can link them using
the Master / Child links of the subform container (control that houses the
subform on the main form).

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________