Where is code for form/subform link

  • Thread starter Thread starter Darrell Childress
  • Start date Start date
D

Darrell Childress

I have a form (based on a table) and a subform (based on a query) that I
designed years ago, but haven't used them in quite a while, and now need
to resurrect. The linking field between the form and subform was named
EmplID, which were fields in the table and query. Those fields are now
called EmplNo. I have updated the information on the form to pull from
the proper field, and I have updated the field on the subform to pull
from the proper field. Now, how do I tell the form and subform to base
the link (common field or child field I think it's called) on EmplNo? I
know that I can delete the subform and then re-place it and go through
the wizard, but I was wondering where the code is. I have to do this
every now and then.
Thanks for your help,
Darrell
 
Open form in design view, right click, scroll down and select Properties.
Click on the extreme upper left corner of the subform.
The Properties window will show the Master/Child links.
 
Look at the properties of the subform control on the parent form,
specifically at LinkChildFields and LinkMasterFields properties.
 
Back
Top