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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form and two Subforms 2
Click a subform field to open relevant form 5
Tabbing between a main form and a subform 1
Subform linking problem 4
Form/Subform Problem 1
Problem linking the second subform to the first one 1
Link between switching subforms 3
Database subform 6

Back
Top