Private Sub Rechercher_Click() Dim maConnexion As ADODB.Connection Set maConnexion = New ADODB.Connection maConnexion.ConnectionString = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Persist Security Info=False;" & _ "Data Source=" & "F:\Users\Romain\Desktop\Management\Base de données.mdb" maConnexion.Open ' Ouvre la connexion. Dim monRS As ADODB.Recordset Set monRS = New ADODB.Recordset With monRS .CursorLocation = adUseClient .Open "Select [Dénomination] From [Produits] Where [Dénomination] Like '%" & Textbox1 & "%' ", maConnexion, adOpenStatic, adLockReadOnly If .RecordCount > 0 Then .MoveFirst Do While Not .EOF ListProd.AddItem monRS.Fields("Dénomination").Value .MoveNext Loop End If .Close End With End Sub