1 2 3 4 5 6 7 8 9 10 11 12 13 14
| Private Sub OK_Click()
Dim i As Variant
dim lFilterVille as string
dim lFilterCapacite as string
Me.Filter = ""
For Each i In Rville.ItemsSelected
lFilterVille = lFilterVille & IIf(lFilterVille = "", "", " OR ") & "Clients_ville= '" & Rville.ItemData(i) & "'"
Next
For Each j In Rcapacite.ItemsSelected
lFilterCapacite = lFilterCapacite & IIf(lFilterCapacite = "", "", " OR ") & "Clients_capacite= '" & Rcapacite.ItemData(j) & "'
next
me.filter = "(" & IIf(lFilterVille = "", "1=1", lFilterVille) & ") AND (" & IIf(lFilterCapacite = "", "1=1", lFilterCapacite) & ")"
Me.FilterOn = True
End Sub |
Partager