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.
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 = NothingObviously, 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.