Adding another table to a form

[Guest]

I am designing an access database and wanted to add other fields from another
table into a form i already created. I know it is possible to connect more
than one table to a form by using the wizard, but how can i do this withough
starting all over again?

 

[Pat Hartman\(MVP\)]

Create a query that joins the two tables and selects all the columns you
need from both tables and save it. Replace the name of the table in the
form's RecordSource with the name of the new query. As long as you selected
all the fields that you are currently using and haven't changed their names,
you'll be all set. Just drag the new fields from the field list to the
form.

 

[Joan Wild]

Open the form in design view and show the properties window. The
RecordSource property probably is a table right now. Click on the build
buttion (...) to the right of that. This will open a QBE window, where you
can add another/more tables and fields.

Not the field list will contain these added fields. You just drag the field
from the field list to a location on your form, optionally choosing the
control type from the toolbox before dragging.

 

[Guest]

Thank you for your response. If I open a QBE window and add more tables,
will those fields from the new table in the form be able to be updated in the
same manner as the fields from the first table?

Thanks for the help!

 

[Guest]

Thanks for the help!

Create a query that joins the two tables and selects all the columns you
need from both tables and save it. Replace the name of the table in the
form's RecordSource with the name of the new query. As long as you selected
all the fields that you are currently using and haven't changed their names,
you'll be all set. Just drag the new fields from the field list to the
form.

 

[Joan Wild]

Generally yes, but there are circumstances where the result won't be
updateable. Try it and see.

You can look up 'updateable query' in Help for more details.