VB6: Dear sir, For the following code I am getting "Run-time error'3265': Item cannot be found in the collection corresponding to the request name or ordinal."
However, I already connected Adodc1 to my database from where I want the data.
Actually, what Im trying to do is, just to get record list from particular field of Table from MSAccess Database in my ComboBox, so I could retrieve the record. I was using DBCombo1 and used "ListField" in the properties and connected it to Adodc1 but I could only succeed in getting records in the list but if I select any record suppose "CustomerID" it is not getting the rest of record like "CustomerName" and "Address" etc. in TextBoxes Im using in my VB Form.
I tried many times but could not succeed. Please if anybody can help me in it. I will be so grateful because I have to finalize my company database with in few days.
Thanks in advance.
Have a Good Day...!!!.
If Adodc1.Recordset.RecordCount <> 0 Then
Adodc1.Recordset.Find "ID='" & DBCombo1.Text & "'"
If Adodc1.Recordset.EOF = False Then
If Adodc1.Recordset!FirstName <> "" Or IsNull(Adodc1.Recordset!FirstName) = False Then
Text1.Text = Adodc1.Recordset!FirstName
Text1.Text = ""
If Adodc1.Recordset!Address <> "" Or IsNull(Adodc1.Recordset!Address) = False Then
Text2.Text = Adodc1.Recordset!Address
Text2.Text = ""
April 14, 2009 7:50 AM
April 15, 2009 6:22 PM