Adding an ADODB-recordset to a combobox

How can I add a recordset to a combobox?


Thanks

You can't technically add a recordset to a combobox, but if you have the name of the recordset (the table?) then you can put the name of the table inside the combobox. When the user selects it you will need to run a query to load that recordset up based on the name in the combobox.

Remember Combo boxes are used to store strings. :)

Francis.

if you mean content of a recordset
here it goes

Code:

---

with RS
    while not .eof
        cboBox.AddItem !MyField
        .moveNext
    wend
end with

---

Try using a data combo box. Set the recordsource property = to the recordset name. Set the listfield property = to the recordset field you want to populate the recordset with.