PDA

Click to See Complete Forum and Search --> : data listing


mahadevank_2000
Nov 24th, 2000, 08:20 AM
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
Nov 28th, 2000, 02:54 AM
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
Nov 28th, 2000, 07:29 AM
Hi,Thank u so much for responding me.I will test it ask for clarification if any.

Regards

Mahadevan