Change link between form and subform

C

Confused87

I have a form with a subform in it.

I would like to change the way they are linked so instead of linking from
Old ID, they link to New ID

I don't know anything about code, is there a way to just change the cell it
relies on?

Thanks
C
 
D

Daryl S

Confused87 -

Bring up the properties of the subform, and change the values in 'Link Child
Fields' and 'Link Master Fields' on the Data tab of the properties dialog
box. Make sure you have the subform selected, not the form within the
subform.
 
Top