I have a filter that i'm using with a combo box, but I have a question which I am sure has a simple solution, but it is eluding me!! The combobox has a value list (A,B,C) and filters based on that selection. What I would like for it to do is filter based on that selection AND another value. The code I have in the after update event is below, and the value I want to add is "5&2," so when it filters all records containing the letter A, B, or C, it will also filter records containing the text "5&2".
Me.Filter = "Team = '" & Me.cmbTeam & "'"
Me.FilterOn = True
If anyone can help me I would really appreciate it!!!!