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
Printable View
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