Hi Folks!
I wonder if you could help me out with my problem... I already know how to filter my subform (datasheet) based on a combobox. The problem is, I dont know how can unfilter it... I have a value "ALL" in my combobox so that If I select it, the subform get's unfiltered. I have searched through different threads here but i can't find the unfilter function.. BTW, I am using this code
The code works pretty well for filtering the subform based on state field but the problem is, I dont have the option to unfilter it. I have already added a value "ALL" and used the code below but to no avail. I know there is some sort of solution or fix to my code... Can you help me out please?
I wonder if you could help me out with my problem... I already know how to filter my subform (datasheet) based on a combobox. The problem is, I dont know how can unfilter it... I have a value "ALL" in my combobox so that If I select it, the subform get's unfiltered. I have searched through different threads here but i can't find the unfilter function.. BTW, I am using this code
Code:
Private Sub Form_Open(Cancel As Integer)
Me.Filter = "(State) = ComboState"
Me.FilterOn = True
End Sub
The code works pretty well for filtering the subform based on state field but the problem is, I dont have the option to unfilter it. I have already added a value "ALL" and used the code below but to no avail. I know there is some sort of solution or fix to my code... Can you help me out please?
Code:
Private Sub Form_Open(Cancel As Integer)
Me.Filter = "(State) = ComboState"
Me.FilterOn = True
If ComboState = ALL Then Me.FilterOn = False
End Sub