Add New Table to Existing Form (Access 2003)

S

Seraphelia

Have two related tables whose fields are linked to controls on a form (made
originally with the Form Wizard). Now I have created another table related
to one of those other tables. What is the best way to get the fields from
the new table to display on the form?

I've tried adding the new table's fields to the form recordsource (and the
new fields are listed in the Field List) but when I go to Form View I get a
little messagebox asking for parameter values. What parameter values does it
want? Or is that not the way to go here?



--- news://freenews.netfront.net/ - complaints: [email protected] ---
 
A

Access Developer

Change the Record Source for that Form to an Updateable Query containing the
fields from both related records that you want to update. Be sure to
include the key fields for both records or the query may not be updateable.
Check help or search for information on updateable queries, and what can
keep them from being updateable.
 
A

Access Developer

Seraphelia said:
Thanks for replying, Larry. That info was very helpful.
Click to expand...

You are most welcome. Helping people use Access is why I participate here
and it's nice to have some feedback that it did help.

Larry Linson
Microsoft Office Access MVP
 
Top