Dim cnx As ADODB.Connection Public rs As ADODB.Recordset Dim mEnum As ADODB.Field Dim cat As New ADOX.Catalog Dim nEnum As ADOX.Table '*******Pour lister les champs Private Sub Table() '# procedure enumere tous les noms de table existentes List1.Clear Set cat.ActiveConnection = cnx For Each nEnum In cat.Tables If nEnum.Type = "TABLE" Then List1.AddItem nEnum.Name Next End Sub '****** liste toutes les tables lorsque click sur list 1 Private Sub Champs() List3.Clear If Not rs.ActiveConnection Is Nothing Then rs.Close rs.Open List1.List(List1.ListIndex), cnx For Each mEnum In rs.Fields List3.AddItem mEnum.Name Next mEnum If List3.ListCount > 0 Then List3.ListIndex = 0 End Sub