devxlogo

Filling from Recordset

Filling from Recordset

Why Trust Us

Question:
How do I fill a combo box with the values from an Access 2.0query or table? I have the compatibility layer installed and everything works except I can’t figure out the combo box.

Answer:
This is a matter of coding it…I’m sure your db connectivity is there. Here’s a sample.

Dim SS as SnapshotSet SS = db.CreateSnapshot(“Table Name”)Do While Not SS.EOF   ComboBox.AddItem SS(“Field Name”)   SS.MoveNextLoopSS.CloseSet SS = Nothing
Obviously, you should put your own table name or query in the CreateSnapshot, and replace ‘Field Name’ with the Field you want to put into the ComboBox.

Disclosure
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

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
View Author
Show More