Using Recordset Object

Question:
I added records to a list box using the datacontrol. Now I would like to use the list1_dblclick procedure to access the recorddblclicked and use it. I know there is the index property, but I want my program to make the record current so I can perform operations on it.

Answer:
What you need to learn to use is the Recordset object. Here’s how you would write your code to access the record the user selected. For this example, I’ll assume the data control is named dcList, and the field name you loaded into your list is called “Customer”.

Sub list1_DblClick()   dcList.Recordset.FindFirst “Customer = ‘” & list1.List(list1.ListIndex) & “‘”   ‘ See the VB documentation on the FindFirst command for more information.     ‘ Basically you are searching the RecordSet for the first Customer who   ‘ matches what was put in the drop list and what was doubleclicked.   if dcList.Recordset.NoMatch then      MsgBox “Customer was not found in recordset.”      ‘ If the NoMatch property is true, the record was not in the RecordSet.       ‘ Since you added records into the list box from the data control, this      ‘ should never happen.      exit sub   end if   ‘ At this point, the Recordset’s current record is set to the item the user    ‘ double-clicked in the list box.  You can access it by viewing    ‘ dcList.Recordset(“Customer”), or replace Customer with whatever field you    ‘ want to look at. End Sub 

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

Top 5 B2B SaaS Marketing Agencies for 2023

In recent years, the software-as-a-service (SaaS) sector has experienced exponential growth as more and more companies choose cloud-based solutions. Any SaaS company hoping to stay ahead of the curve in this quickly changing industry needs to invest in effective marketing. So selecting the best marketing agency can mean the difference

technology leadership

Why the World Needs More Technology Leadership

As a fact, technology has touched every single aspect of our lives. And there are some technology giants in today’s world which have been frequently opined to have a strong influence on recent overall technological influence. Moreover, those tech giants have popular technology leaders leading the companies toward achieving greatness.

iOS app development

The Future of iOS App Development: Trends to Watch

When it launched in 2008, the Apple App Store only had 500 apps available. By the first quarter of 2022, the store had about 2.18 million iOS-exclusive apps. Average monthly app releases for the platform reached 34,000 in the first half of 2022, indicating rapid growth in iOS app development.