Display results of a 2-column ComboBox

Hi,

How do I have a 2-column ComboBox on a form display both column results after a selection has been made? I can get the first or second column to display after the selection, but not both. For example, column 1 are employee names and column are departments. After making a selection, I can only get either the name or the department to display in the ComboBox, not both.

I've seen a couple of postings on this, but no resolution. Is it because it's just not possible with a ComboBox?

Thanks,

Lawrence