Setting Link Master Field in VB

[mnbuckland]

Can anyone assist in how to set the Link Master Field and the Link Child Field property in Visual Basic.
I need to set the property in the Open Report action

Thanks in advance

 

[MarkK]

Welcome to the forum.
I'd do something like this:

Private Sub Report_Open(Cancel As Integer)
[COLOR="Green"]   'reference the subreport control[/COLOR]
   With Me.YourSubreportControl
[COLOR="Green"]      'set a couple of its properties[/COLOR]
      .LinkMasterFields = "YourReportLinkField"
      .LinkChildFields = "YourSubreportLinkField"
   End With
End Sub

 

[mnbuckland]

Thank you for the prompt reply. Entered the code as suggested and the report works fine.

Thanks again