Display fields from multiple tables in a form that I can enter dat

[VolunteerCoordinator]

I need to create a form that I can use to enter and manage data from/for my
HomeRepairs table. But I would also like the form to display information
(that I won't need to edit) from other tables (like Phone Number and Address
data that's stored in my Constituents table). The common field in all the
tables is the ConID (Constituent ID).

I've created a query that pulls (almost) all the information I want
displayed, but when I create the form based on it, I can't enter any data.

How can I create a form with fields from multiple tables that I can actually
USE as a form to enter some data on?

Any help would be greatly appreciated! Thank you so much!

 

[John W. Vinson]

I need to create a form that I can use to enter and manage data from/for my
HomeRepairs table. But I would also like the form to display information
(that I won't need to edit) from other tables (like Phone Number and Address
data that's stored in my Constituents table). The common field in all the
tables is the ConID (Constituent ID).

I've created a query that pulls (almost) all the information I want
displayed, but when I create the form based on it, I can't enter any data.

How can I create a form with fields from multiple tables that I can actually
USE as a form to enter some data on?

Any help would be greatly appreciated! Thank you so much!

You can display data from the Contituents table a couple of ways. One would be
to use a Form based on one of your tables (the "one" side of the relationship)
and a Subform based on the other; another would be to include the fields that
you want to see in the Row Source of a combo box, bound to the ConID field in
your repairs table. You can put textboxes on the form with control sources
like

=cboConID.Column(n)

where cboConID is the name of the combo box and n is the zero based index of
the field you want to see. A third would be to use textboxes with control
sources such as

=DLookUp("[Phone]", "[Constituents]", "[ConID] = " & cboConID)