Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Navigating a recordset with a listbox

Status
Not open for further replies.

JESTAR

Programmer
Feb 13, 2002
213
GB
I've loaded the Names field from my recordset into a listbox, the idea being click on a name in the listbox and the data for that person appears in several textboxes. What property of the recordset object do I use to move to the row the user has selected? There is an ID (autonumber) field. ie if the user selects the 9th person in the listbox (listName.ListIndex = 9) then the recordset moves down to the 9th row...
 
Have a look at the Filter property and the Find method of the recordset object.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top