Vb problem
Thread Starter
Scooby Regular
Joined: Feb 2002
Posts: 7,951
Likes: 0
From: Lurkin Somewhere
Right,
in a combo box ive loaded out the sap number eg 12345
When i select a sap number i want it to put to screen the other data releated to that Records set, how do i do it?
Private Sub cboSAP_Change()
Dim strConn As String
Set rsMatch = New ADODB.Recordset
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\dad.mdb;"
dbConnection.Open strConn
rsMatch.Open "sapno"", strConn, adOpenKeyset, adLockOptimistic, adCmdTableDirect"
If cboSAP.Text = rsMatch!sap Then
txtcat.Text = rsMatch!ABCatNo
Else
End If
End Sub
what i did but failed
in a combo box ive loaded out the sap number eg 12345
When i select a sap number i want it to put to screen the other data releated to that Records set, how do i do it?
Private Sub cboSAP_Change()
Dim strConn As String
Set rsMatch = New ADODB.Recordset
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\dad.mdb;"
dbConnection.Open strConn
rsMatch.Open "sapno"", strConn, adOpenKeyset, adLockOptimistic, adCmdTableDirect"
If cboSAP.Text = rsMatch!sap Then
txtcat.Text = rsMatch!ABCatNo
Else
End If
End Sub
what i did but failed
Thread
Thread Starter
Forum
Replies
Last Post