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.

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

Related Posts