das habe ich bis jetzt:
Option Explicit
Dim gvConnection As ADODB.Connection
Dim gvRs As ADODB.Recordset
Dim lngComboIndex As Long
'-Verbindung zur Datenbank herstellen
Private Sub cmdConnect_Click()
'-Comboboxen leeren
Me.DBComboKFZ.Clear
Me.DBComboKFZI_ID.Clear
Set gvConnection = New ADODB.Connection
With gvConnection
.ConnectionString = ".\Fahrbereitschaft.mdb"
.Provider = "Microsoft.Jet.OLEDB.4.0"
.CursorLocation = adUseClient
Call .Open
End With
If gvConnection.State = 1 Then
'-Status: rot unvisible, gruen visible
Me.lblNichtVerbunden.Visible = False
Me.lblVerbunden.Visible = True
Set gvRs = New ADODB.Recordset
gvRs.Open "T_KFZ", gvConnection, adOpenDynamic, adLockReadOnly
'-Springe zum ersten Datensatz
gvRs.MoveFirst
lngComboIndex = 0
While Not gvRs.EOF
Me.DBComboKFZ.AddItem (gvRs!F_registrationnumber), lngComboIndex
Me.DBComboKFZI_ID.AddItem (gvRs!I_ID), lngComboIndex
gvRs.MoveNext
lngComboIndex = lngComboIndex + 1
Wend
Else
MsgBox ("Fehler beim Verbinden der Datenbank")
'-Status: gruen unvisible, rot visible
Me.lblVerbunden.Visible = False
Me.lblNichtVerbunden.Visible = True
End If
End Sub
-----------------------------------------------------------------
Private Sub DBComboKFZ_Click()
'-Index mit dem Kennzeichen abgleichen
Me.DBComboKFZI_ID.ListIndex = Me.DBComboKFZ.ListIndex
Set gvRs = New ADODB.Recordset
gvRs.Open "T_KFZ", gvConnection, adOpenDynamic, adLockReadOnly
With gvRs
Set .ActiveConnection = gvConnection
.Source = "SELECT T_KFZ.F_registrationnumber, _
T_KFZ.F_manufacturer, _
T_KFZ.F_type _
FROM T_KFZ _
WHERE T_KFZ.I_ID=" & Me.DBComboKFZI_ID.ListIndex & ";"
Me.txtManufacturer.Text = gvRs!F_manufacturer
Me.txtType.Text = gvRs!F_type
End With
End Sub
mach nicht viel mit VB....
bin dabei das alles zu lesen, aber so richtig finde ich da nicht, was ich brauche...
gruß