Moving the recordset

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

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

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