data listing

[mahadevank_2000]

Dear friends,
I have connected my odbc connection using ADO.I have 5 to 6 fields.I am displaying my first in a datacombo,on selecting a data in datacombo i am searching the recordsets matching to datacombo.text.
My requirement is i want to display the field2 in a datalist which will display the filtered recordset(field2) and the remaining fields i want to diplay in textboxes.Here on selecting a data in the datalisting the other field in the table should change dynamically.

KINDLY HELP ME !!!!!!

MAHADEVAN

[Edneeis]

this sets the recordset to the current record selected in the databcombo. dat is a dataenvironment and rsqTest is a recordset.

Private Sub DataCombo1_Click(Area As Integer)
If Area = 2 Then
    dat.rsqTest.Bookmark = DataCombo1.SelectedItem
End If
End Sub

[mahadevank_2000]

Hi,Thank u so much for responding me.I will test it ask for clarification if any.

Regards

Mahadevan