Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Link combobox with access table using VB 6
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