devxlogo

Retrieving Info From Listbox

Retrieving Info From Listbox

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.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist