brorick
10-09-2006, 02:41 PM
Hello. I would like to open a subform based on the selection from my combo list. I have the following code I thought would work for me, but I don't think I am using it in the correct event. I currently have it listed on the Change event for my combo list named Combo58. My combo list has on two options: View All, By Department.
Private Sub Combo58_Change()
Select Case Me.Combo58
Case "View All"
Me.subformcontrol.SourceObject = "Frm_QuickGuide"
Case "By Department"
Me.subformcontrol.SourceObject = "Frm_Splash"
'and so on...
End Select
End Sub
Is it possible that if the user selects Department that the open subform can be filtered based on a field titled DeptID? Any help is appreciated. Thank you in advance. :hi:
Private Sub Combo58_Change()
Select Case Me.Combo58
Case "View All"
Me.subformcontrol.SourceObject = "Frm_QuickGuide"
Case "By Department"
Me.subformcontrol.SourceObject = "Frm_Splash"
'and so on...
End Select
End Sub
Is it possible that if the user selects Department that the open subform can be filtered based on a field titled DeptID? Any help is appreciated. Thank you in advance. :hi: