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

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


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>