multiiple filter on a split form

[webisti]

hi I do have a split form with two filters on it
first code is:

Private Sub S_CHOOSE_PLANT_Click()
If Not IsNull(Me![PLANT]) Then
Me.Filter = "PLANT =" & Chr(34) & Me![PLANT] & Chr(34)
Me.FilterOn = True
End If
End Sub
and then the secodn code is :

Private Sub filter_besoh_Click()
test = Me.filter_besoh
Select Case Me.filter_besoh
Case 1
Me.Filter = "Priority = 'Priority*'"
Me.FilterOn = False
Case 2


Me.Filter = "Priority = 'Priority 1'"
Me.FilterOn = True
Case 3
Me.Filter = "Priority = 'Priority 2'"
Me.FilterOn = True
Case 4
Me.Filter = "Priority = 'Priority 3'"
Me.FilterOn = True
End Select
End Subho can I make it possible that when i run the first filter and it workds then I do run the second filter and keep the filtered records done already..
any ideas?

thanks a lot

webisti

[June7]

You would have to concatenate the two criteria into one filter expression.