Linking a subform to a subform 2

[lck092580]

Hi,

I was wondering if it's possible to link a subform to a subform that's in a main form.

Basically what I have is a main form on one tab. Then another subform that's linked to the main form on the second tab. I want to put another subform in there but the wizard forces me to link it with the main form and not the subform in the second tab. Anyone know how I can accomplish this? Thanks.

 

[TheAceMan1]

How are ya lck092580 . . .

Perhaps faq702-5860 will help! . . .

See Ya! . . . . . .

 

[Pampers]

or...
To link Subform2 To Subform1 in a Mainform, in Subform2 you put:
Link Master Field Property: [Subform1].Form![OrderID]
Link Child Field: [OrderID]
Note: refer directly to the subform without refering the mainform first!

'to synchronize Subform2 with Subform1, Put in Subform1 in the On Current Event:

Private Sub Form_Current()

 'Sync Subform2 with Subform1
    Dim strParentDocName As String

    On Error Resume Next
    strParentDocName = Me.Parent.Name

    If Err <> 0 Then
        GoTo Form_Current_Exit
    Else
        On Error GoTo Form_Current_Err
        Me.Parent![Subform2].Requery
    End If

Form_Current_Exit:
    Exit Sub

Form_Current_Err:
    MsgBox Err.Description
   Resume Form_Current_Exit
End Sub

Pampers
Keeping it simple can be complicated

 

[lck092580]

Thanks guys. Worked like a charm!