1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Private Sub Nom_KeyDown(KeyCode As Integer, Shift As Integer)
strRowSource = "SELECT [Nom],[Prenom],[Code_Postal],[Commune],[Sport],[Statut], [Categorie]" & "FROM T_Abonnes " & _
"WHERE [Nom] like '*" & Me.Nom.Text & "*' AND [Categorie] = 'BADMINTON'"
Liste_check.RowSource = strRowSource
End Sub
Private Sub Prenom_KeyDown(KeyCode As Integer, Shift As Integer)
strRowSource = "SELECT [Nom],[Prenom],[Code_Postal],[Commune],[Sport],[Statut], [Categorie]" & "FROM T_Abonnes " & _
"WHERE [Prenom] like '*" & Me.Prenom.Text & "*' AND [Categorie] = 'BADMINTON' AND [Nom]= 'dupond'"
'strRowSource = "SELECT [Nom],[Prenom],[Code_Postal],[Commune],[Sport],[Statut], [Categorie]" & "FROM T_Abonnes " & _
'"WHERE [Prenom] like '*" & Me.Prenom.Text & "*' AND [Categorie] = 'BADMINTON' AND [Nom]= 'Me.Nom'"
Liste_check.RowSource = strRowSource
End Sub |
Partager