Retrieving Info From Listbox

Retrieving Info From Listbox

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

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.


Share the Post: