Add New Table to Existing Form (Access 2003)

[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: (e-mail address removed) ---

 

[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.

 

[Seraphelia]

Thanks for replying, Larry. That info was very helpful.



--- news://freenews.netfront.net/ - complaints: (e-mail address removed) ---

 

[Access Developer]

Thanks for replying, Larry. That info was very helpful.

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