Change the field linking a form and sub form

[richardlowe]

Hi, I have a form with a subform, created by the subform wizard. Both
forms are based on simple *linked* tables from Sql Server. The linked
tables have been updated, so there are changed column names, and now I
would like to change the column that links the parent form to the
subform.

I cannot find a field to change that does this!!! How can I modify the
parent or subform so that it links on the NEW column name (instead of
prompting me).

thanks
Richard

 

[tina]

open the main form in design view. click once on the subform control (within
the main form) to select it, and look at the Properties box. you'll see the
LinkChildFields and LinkMaster fields properties, which should display the
linked fields' names. correct the "changed" fieldname there.

hth