UPDATING THE LINK BETWEEN FORM AND A SUBFORM

  • Thread starter Thread starter John Gun
  • Start date Start date
J

John Gun

I've created a form and linked in a subform on ORDER NUMBER. I've now been
asked to change this link to ORDER NUMBER and ORDER LINE however I can't
figure out a way of updating the link witout recreating the subform from
scratch using the wizard.

Can anyone help?

John.
 
The subform has the properties Link Child Field and Link Master Field. There you can define the link between the main and subform. Then you don't have to create the subform again.
 
I've created a form and linked in a subform on ORDER NUMBER. I've now been
asked to change this link to ORDER NUMBER and ORDER LINE however I can't
figure out a way of updating the link witout recreating the subform from
scratch using the wizard.

Can anyone help?

John.
Click to expand...

Open the mainform in design view, and view the Properties of the
subform control; edit the Master and Child Link Field properties to

[Order Number];[Order Line]

with a semicolon as delimiter.
 
Back
Top