combo box, 2 columns [*Resolved *]

[steve_rm]

Hello,

I have a database table with 2 fields, DepartmentCode, and DepartmentName. I want to add the values of these 2 fields into a combo box from the database. I can add one field, but how can you add 2 fields to the combox so that when the user clicks it, it will display all the departmentCode and Department name in 2 columns.

I can do this with just one field, but l am having trouble tying to display the extra field. Is this possible in a combox box?

Thanks in advance,

Steve