MultiColumn Combo Box on Userform

[dwbennett]

I need this combo box to load multiple columns for knowledge selection from the list and can't seem to get it to work.

Please Login or Register  to view this content.

Recordset fields 2,3,8,4 help identify the correct record.

This loads all the data correctly in the 20 fields of the records, but the combo box only shows the name so that when they are choosing, they cannot see enough associated data to make a logical choice. All the fields on the form are read only and so the entire lookup happens from 1 combobox.



Appreciate any help.

[pjwhitfield]

Have you set the column widths in the Properties?

EDIT that: You're only telling it to populate with one column so where do you expect it to get the rest of the data from?

[Kyle123]

In addition to the above, you also need to set the column count

[dwbennett]

I set columns to 6 in the properties box of the combobox TCOName and set the widths to the widths for the six columns. It only loads the Names.

Is the TCOName.column = Get Rows() where the six column definition goes and what would be the syntax for that entry?

I.E TCOName.columns = GetRows 1,4,6,3 etc ()

[dwbennett]

What would be the settings in the combo box properties on the form or does the settings name here carry into that box?

[Kyle123]

Reread, the post above, you're missing the point, this:

Please Login or Register  to view this content.

Only selects the names, that's why that's all your getting

[dwbennett]

So the syntax for that should be

Please Login or Register  to view this content.

?

[Kyle123]

Yes, depending on the field names

[dwbennett]

Thanks I will try that when I get home and hopefully that will solve this thread.

[dwbennett]

Thank you so much. Still trying to get used to many ways to accomplish similar things and which one to use in each location. Your help is very appreciated