Set Child/Parent properties from main form

[Design by Sue]

Can someone please help me with the code for VBA to set the child/parent properties for a sub form from the main? I have been able to set the record source, but can't find the correct vba term for the child/parent properties.

I know this is basic stuff from many of you, but I have searched and can't find the exact code to use - the posts seem to only refer to "control source" or the like.

Thanks

 

[smig]

No need for vba
When you put a sub form on the main form you set the masterField and childField in the Data property tab.
Open the main form in design mode. Select the subform and open the prperties window.

 

[Design by Sue]

OK - thanks for the response. I was getting an error but after your comment, realized the error was from the Subform on the Subform. I corrected the error and now the child parent linking is working correctlly

Thanks