I have an unbounded Form Called [frmTestsMain] which includes 3 subforms:
and
But when I included the [frmTestsMain] from in A navigation form with a min from , i get an error.
I tried to modify the code like the following but I get the same problem
Could you help me please. Thanks
- [frmTestsList]
- [frmTMGroupList]
- [frmTSGroupList]
- [frmTMGroup] has a filed "TMGroup",
- [frmTSGroup] has a filed called "TSGroup" and another lookup filed "TMGroup" linked to [frmTMGroup].TMGroup.
- [frmTestsList] has lookup filed "TSGroup" linked to [frmTSGroup].TSGroup.
- When I click [frmTMGroup].TMGroup, the other subform [frmTSGroup] to be filtered to get only TMGroup clicked.
- When I click [frmTSGroup].TSGroup, the other subform [frmTestsList] to be filtered to get only TSGroup clicked.
Code:
Private Sub TestMGroup_Click()
Forms![frmTestsMain]![frmTSGroupList].Form.Filter = "TestMGroup =" & Me.ID
Forms![frmTestsMain]![frmTSGroupList].Form.FilterOn = True
End Sub
Code:
Private Sub TestSGroup_Click()
Forms![frmTestsMain]![frmTestsList].Form.Filter = "TestSGroup =" & Me.ID
Forms![frmTestsMain]![frmTestsList].Form.FilterOn = True
End Sub
I tried to modify the code like the following but I get the same problem
Code:
Private Sub TestMGroup_Click()
Forms![frmMain]![NaviTests]![frmTestsMain]![frmTSGroupList].Form.Filter = "TestMGroup =" & Me.ID
Forms![frmMain]![NaviTests]![frmTestsMain]![frmTSGroupList].Form.FilterOn = True
End Sub