filling a two column listbox from a two column recordset

[Dennis]

Is there a way to fill a two column listbox on a userform
from a SQL recordset? I want the user to be able to make
multiple selections from this listbox. And then I want to
write an update SQL back to a table.

Thank you in advance, Dennis

 

[Tom Ogilvy]

http://support.microsoft.com/default.aspx?scid=kb;en-us;244761&Product=xlw
XL2000: How to Use ADO to Return Data to a ListBox or ComboBox

 

[Dennis]

Tom,

Thank you. However, I'm having trouble with filling the
second column. My two fields fill in the first column.

Any ideas?

Dennis

 

[Tom Ogilvy]

Left out the End With

Do Until rstEmployees.EOF
with UserForm1
.ComboBox1.AddItem rstEmployees!lName
.Combobox1.List(.combobox1.Listcount-1,1) = rstEmployees!fName
End with

 

[Dennis Brininger]

Tom,

Thank you very much for helping me. I got it to work
before your last note. I really do appreciate your quick
response - sorry I'm late getting back.

Dennis