devxlogo

Load a Combobox/Listbox From a Recordset

Load a Combobox/Listbox From a Recordset

This is a fast and versatile function for loading comboboxes.I have not included a ComboBox.Clear, to make it possible to load multiple recordsets to the combobox. This makes it more versatile. It’s also possible to change the first parameter to a ListBox. To use DAO, change the second parameter to DAO.Recordset. and the field Variables to DAO.Field.

 'Simple syntax:'    LoadCombo Combo1, rsTemp,

devx-admin

Share the Post: