Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub Form_Load() 'Connexion à la table Contact via la connexion BD Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Persist security info=false;data source=C:\Multi-Gestion\bd\multigest.mdb" Adodc1.RecordSource = "Contact" 'Définition du contenu du DataCombo With DtaCName Set .DataSource = Adodc1 Set .RowSource = Adodc1 .ListField = "Nom" End With End Sub Private Sub TxtSurname_Change() Adodc1.RecordSource = "Contact" With DtaCName Set .DataSource = Adodc1 Set .RowSource = "SELECT Nom FROM Contact WHERE Prenom LIKE '" & TxtSurname.Text & " % ' ORDER BY Prenom ;" .ListField = "Nom" End With DtaCName.Refresh End Sub