Data Retrieval to a ListBox

Question:
I need to know how to retrieve multiple data and put it in a listbox. This data is also indexed to another database by it customer id. I can retrieve all data except for the list box.

Answer:
If you are retrieving this data from a database, you can simply loopthrough the records in the recordset and call AddItem on the list box toadd each record to it. For instance:

Dim rsData as RecordsetSet rsData = db.OpenRecordset(“Employees”)Do While Not rsData.EOF   ListBox.AddItem rsData(“Name”)   rsData.MoveNextLooprsData.Close

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

Overview

Recent Articles: