LinkChildFields property

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

 

[SyedAqif]

Well....thats simple.....Just place the Subform on ur main form, rite click on the subform n choose properties. Then click on the data tab n u'll c LinkChildField and LinkMasterField. U'll also c a build button , click the build button n from different tables choose the link fields.

Good Luck.

Cheers!
Aqif

 

[Paul7905]

thanks Aqif, that worked beautifully!

Paul