Dim Requete As String Private Sub Combo1_Click() If Combo1.Text = "Tous" Then Requete = "SELECT * FROM Produits ;" Else Requete "SELECT * FROM Produits WHERE Payement '" & Combo1.Text & "';" End If End Sub Private Sub Command1_Click() MsgBox Requete End Sub Private Sub Form_Load() Combo1.AddItem "Tous" Combo1.AddItem "Espcèce" Combo1.AddItem "Traite" Combo1.AddItem "Chèque" Combo1.ListIndex = 0 End Sub