Second Combo Box Filter
Posted on 2014-01-14
I have Access 2010. I have a continuous form. I have one combo box (cbo_BranchSearch) that filters my form
Private Sub cbo_BranchSearch_AfterUpdate()
If Me.cbo_BranchSearch & "" <> "" Then
Me.Filter = "[PriKey] = " & Me.cbo_BranchSearch
Me.Filter = ""
Me.FilterOn = True
I have a second combo box (cbo_LocationUser) that's rowsource is similar to the first cbo pointing to my query qry_ElistSearch, in which the form gets its data.
The first cbobox works great. Now I would like the second cbo to be filtered based on what I selected on the first cbo. Then when I see those, it would then filter my continuous form from my selection on the second. I am sure this question is asked many times. But I think I am not phrasing the question right on my search so my apologies. Thanks you so much. It has been awhile since I used VBA. Any help is much appreciated.