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.

devx-admin

Share the Post: