Adding an ADODB-recordset to a combobox

[Deju]

How can I add a recordset to a combobox?


Thanks

[Paylo]

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.

[kovan]

if you mean content of a recordset
here it goes

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

[666539]

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.