ExcelBanter - vb combo box

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - vb combo box (https://www.excelbanter.com/excel-programming/325221-vbulletin-combo-box.html)

I have a VB6 form that I want to fill with data from a field in an Access
DB. I get the connection and the first field, but want the whole column to
show up as the combo box items so that one can be selected, then when saved,
populate and/or update another Access table. Can anyone help me cause the
whole column to display instead of only the first record?

a combobox will only display the selection from a single column.

If you mean the dropdown only displays a single column, then change the
columncount property.

--
Regards,
Tom Ogilvy

"David" wrote in message
. uk...
I have a VB6 form that I want to fill with data from a field in an Access
DB. I get the connection and the first field, but want the whole column to
show up as the combo box items so that one can be selected, then when
saved,
populate and/or update another Access table. Can anyone help me cause the
whole column to display instead of only the first record?