Moving the recordset

[Roy]

How do I click on the data within a listbox and get the data control to jump to that recorset position. Can anyone help me.


Thanks


Roy

[HQC]

You can take the content of selected text, then use find method of Recordset object to jump to this record !

[Ravi Kiran]

Hi,


Use the 'BookMark' property. I assume you are using DBList ( bound list control)

Code sinppet would look something like this:


Private Sub DBList1_Click()

If Data1.Recordset.Bookmarkable Then

Data1.Recordset.Bookmark = DBList1.SelectedItem

End If

End Sub


sometimes you may need a .refresh if you are using some complicated recordset

resulted from a SQL etc. Note : the derived recordset should be bookmarkable


Ravi