devxlogo

Filling from Recordset

Filling from Recordset

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.
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