Question:
I have a listbox with some names loaded from a recordset, I have also associated the memberID with its associated name as in the following:

lstMember.ItemData(lstMember.NewIndex)= rsMembers![MemberId].

I want to double-click the lstMember_dblclick event to retrieve the particular person’s details which will be displayed in another form (member detail info).Could anybody kindly help me accomplish that process?Thank you in anticipation.John

Answer:
If you keep the recordset open, it’s no problem?just use a Find method to find the record in question.

If the recordset isn’t open, you’ll need to open a new recordset for this particular member ID.