I am using cascading combo-boxes (I have 2 of them) and when I make a selection in the first combobox the second combobox requeries (like I want it to) but when I make a selection from the second combobox it disregards the first combobox selection and requeries the form based on only that selection.
I have the following code:
Private Sub Combo44_AfterUpdate()
Me.FilterOn = True
Me.Filter = "Book = Forms![AIM_OfferInfo]![Combo44]"
Me.Form.Requery
End Sub
***************************************************
Private Sub Combo44_Change()
Combo46.Requery
End Sub
***************************************************
Private Sub Combo46_AfterUpdate()
Me.FilterOn = True
Me.Filter = "YrSeason = Forms![AIM_OfferInfo]![Combo46]"
Me.Form.Requery
End Sub
****************************************************
I also have [Forms]![AIM_OfferInfo]![Combo44] in my row source.
I need my form to filter for the YrSeason based on the Book selection. Any tips?
I have the following code:
Private Sub Combo44_AfterUpdate()
Me.FilterOn = True
Me.Filter = "Book = Forms![AIM_OfferInfo]![Combo44]"
Me.Form.Requery
End Sub
***************************************************
Private Sub Combo44_Change()
Combo46.Requery
End Sub
***************************************************
Private Sub Combo46_AfterUpdate()
Me.FilterOn = True
Me.Filter = "YrSeason = Forms![AIM_OfferInfo]![Combo46]"
Me.Form.Requery
End Sub
****************************************************
I also have [Forms]![AIM_OfferInfo]![Combo44] in my row source.
I need my form to filter for the YrSeason based on the Book selection. Any tips?