HOWTO: Navigate to a Record in a Separate Report

09-30-2005, 7:06 PM
You can navigate to a separate report using the hyperLink event.  Passing the hyperlink's value to the separate report allows you to navigate to the specified record.

In the Report 1 form:
Private Sub ARViewer21_hyperLink(ByVal Button As Integer, Link As String)
    Dim frm As New frmSub
    frm.Target = "Linked"
    frm.Show
End Sub

In the Report 2 form:
Private Sub ARViewer21_LoadCompleted()
    Me.ARViewer21.TOC.Navigate m_TargetValue
End Sub