Where is code for form/subform link

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
 
K

KARL DEWEY

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.
 
D

Douglas J. Steele

Look at the properties of the subform control on the parent form,
specifically at LinkChildFields and LinkMasterFields properties.
 

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

Top