Bharat Mehta wrote:
> *I am using ADODatacontrol in my form, when I link TextBox with ADODC
> it
> shows me the records, but when I link this ADODC with ListBox it does
> not
> show any data. Please advice. *
Here is another way you may place data in a combox
Dim cn As New ADODB.Connection
Dim RS As New ADODB.Recordset
Dim MySQLString As String
cn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
App.Path & "\YourDatabaseNAme.mdb;Persist Security " & _
"Info=False"
With Adodc1
RecordSource = _
"SELECT TableName.FieldName1, TableName.FieldName2" & _
" FROM TableName "
ConnectionString = cn
Refresh
Caption = "Items"
Visible = False
End With
RS.Close
cn.Close
If I can help anymore please let me know
--
Excalibur Software
------------------------------------------------------------------------
Posted via <a rel="nofollow" style='text-decoration: none;' href="http://www.codecomments.com" target="_blank">http://www.codecomments.com</a>
------------------------------------------------------------------------
>> Stay informed about: ListBox with ADODC