Question

Locked

Link combobox with access table using VB 6

By abbas_kashif2003 ·
Hi,

I am trying to connect combobox with access table to call some data on combobox below is the code which i have used but there is some problem with the code.
can any plz help me where i am going wrong

Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source=" & App.Path & "\contract_management.mdb"
cn.Open
cn.CursorLocation = adUseClient
rs.Open "select client_name from masterdata", cn, adOpenDynamic, adLockOptimistic

With rs
While rs.EOF
Combo1.AddItem
.MoveNext
Wend
End With

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums