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:
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.
If you keep the recordset open, it's no problemjust 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.