Linking Sub Forms

[Sri99]

Hi all
I have been failing to linking sub forms to main forms.
can any one explain me what are the parameters have to be set?


Regards
Sri

 

[James Dudden]

To start with ou need a common field that the 2 forms can link on. Then you need to add the details of the 'linking' fields to the subofrms Data properties as follows:

Open the properties for the subform.
Click on the Data tab.
Enter the linking field for the main form in the 'Link Master Fields' section.
Enter the linking field for the subform in the 'Link Child Fields' section.

 

[Sri99]

Hi Thank u

I been trying the same as you said, but its not giving result.
I want report like " when I choose data by drop down in the main form (2fields) then automatically all of the fields in the sub form should pick/show the data in their fields". tell me one thing... Can I choose any field in the sub form Is it right? or any specifications?

regards
Sri

To start with ou need a common field that the 2 forms can link on. Then you need to add the details of the 'linking' fields to the subofrms Data properties as follows:

Open the properties for the subform.
Click on the Data tab.
Enter the linking field for the main form in the 'Link Master Fields' section.
Enter the linking field for the subform in the 'Link Child Fields' section.

 

[jdraw]

You may get some ideas from this form/subform tutorial
https://www.youtube.com/watch?v=YZKN_-P6wck