Vb problem
25 June 2002, 06:05 PM
#1
Scooby Regular
Thread Starter
Join Date: Feb 2002
Location: Lurkin Somewhere
Posts: 7,951
Likes: 0
Received 0 Likes
on
0 Posts
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