Public connection As ADODB.connection Public comm As ADODB.Command Public table As ADODB.Recordset Private Sub ComboBox1_Click() chargeTable ComboBox1.List(ComboBox1.ListIndex) End Sub Private Sub Command1_Click(Index As Integer) Load Form2 Form2.chargeEnregistrement ComboBox1.List(ComboBox1.ListIndex), ListView1.SelectedItem.Text Form2.Show End Sub Private Sub Form_Load() Dim i As Long Dim j As Long Set connection = New ADODB.connection Set table = New ADODB.Recordset Set enregistrement = New ADODB.Record Set comm = New ADODB.Command connection.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=nom_de_ta_base;USER=user;PASSWORD=pwd;OPTION=3;" connection.Open Set table = connection.Execute("show tables") table.MoveFirst i = 1 While Not table.EOF ComboBox1.AddItem table(0) table.MoveNext Wend table.Close Set table = Nothing End Sub Private Sub chargeTable(sNomTable As String) Set table = connection.Execute("select * from " & sNomTable) ListView1.ListItems.Clear ListView1.ColumnHeaders.Clear table.MoveFirst i = 1 For i = 0 To table.Fields.Count - 1 ListView1.ColumnHeaders.Add , , table.Fields(i).Name Next i i = 1 While Not table.EOF ListView1.ListItems.Add , , table(0) For j = 1 To table.Fields.Count - 1 If IsNull(table(j)) Then ListView1.ListItems(i).SubItems(j) = "" Else ListView1.ListItems(i).SubItems(j) = table(j) End If Next j i = i + 1 table.MoveNext Wend table.Close Set table = Nothing End Sub Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer) connection.Close Set connection = Nothing End Sub