LinkChildFields, LinkMasterFields Properties

[Paul7905]

Has anyone ever used these properties? I read about them in access Help but cannot find the properties anywhere.

The Access 2000 help documentation reads as follows:

Setting

You can set the LinkChildFields and LinkMasterFields properties for the subform, subreport, or embedded object as follows:

The LinkChildFields property. Enter the name of one or more linking fields in the subform, subreport, or embedded object.


The LinkMasterFields property. Enter the name of one or more linking fields or controls in the main form or report.

You can use the Subform/Subreport Field Linker to set these properties by clicking the Build button to the right of the property box in the property sheet.

 

[Lightning]

Hi Paul

Yes, these properties are used all the time. They relate to a situation where you have a main form and an embedded subform. The LinkChildField and LinkMasterField are properties of the subform control on the main form. (Note: NOT of the subform itself). They can be viewed and set through the control's Property Sheet.

By setting the LinkChildField and LinkMasterField properties, you establish a direct link between the main form and the subform which allows the subform to display records directly related to the record displayed on the main form. As the main form's displayed record changes, so will the information displayed by the subform.

All in all, a v-e-r-y handy property to have.

HTH
Lightning