Aqui mi codigo
Código:
Private Sub Form_Load() Dim Datos As ADODB.Connection Dim Tabla As ADODB.Recordset Dim Index As Integer Set Datos = New ADODB.Connection Datos.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _ & "SERVER=localhost;" _ & "DATABASE=bar;" _ & "UID=root;PWD=****; OPTION=3" Datos.Open Datos.DefaultDatabase = "bar" Datos.CursorLocation = adUseClient Set Tabla = New ADODB.Recordset Source = "Select * From consumiciones" ActiveConnection = Datos CursorType = adOpenStatic CursorLocation = udUseClient LockType = adLockOptimestic Tabla.Open Source, Datos, adOpenStatic, adLockOptimistic, adCmdUnknown If Tabla.Fields("id") = Botón(Index).Caption Then Botón(Index).Caption = Tabla.Fields("nombre") End If End Sub