1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
| Sub FiltreStadeint_Click()
Call MultiSelect(Form_Researchform.FiltreStadeint)
End Sub
Sub FiltreSecteur_Click()
Call MultiSelect(Form_Researchform.Filtresecteur)
End Sub
Private Sub cmdfiltre_Click()
Dim filter As String
If IsNull(FiltreStadeint) Then
If IsNull(filter) Then filter = filter & " AND "
filter = filter & "(((XXX.[Stade d'intervention].Value) " & l_strFiltre
End If
If IsNull(Filtresecteur) Then
If Not IsNull(filter) Then filter = filter & " AND "
filter = filter & "(((XXX.[Secteur_Activite].Value) " & l_strFiltre
End If
Dim sql As String
sql = "SELECT XXX.Nom, XXX.Type, XXX.[Stade d'intervention]," _
& " XXX.Position, XXX.Secteur_Activite, Nz([XXX].[XXX]," & Chr$(34) & Chr$(34) & ") AS [XXX]" _
& " , Nz([XXX].[XXX]," & Chr$(34) & Chr$(34) & ") AS [XXX], Nz([XXX].[XXX]," & Chr$(34) & Chr$(34) & ") AS [XXX]," _
& " Nz([XXX].[XXX]," & Chr$(34) & Chr$(34) & ") AS [XXX], XXX.[XXX]" _
& " FROM XXX"
If Not IsNull(filter) Then
sql = sql & " WHERE " & filter
End If
Me.Researchsubform.Form.RecordSource = sql
Me.Researchsubform.Requery
End Sub |
Partager