display all columns in cbo selection box

[Brian.Crawford]

I have a combobox (on a form) with 4 columns (1st column is bound). When I select an item from the list I want to display all 4 columns of the selected item in the cbo's textbox (or whatever where the displayed result goes is called). It shows all 4 columns in the dropdown list when I click the down-arrow. It currently only shows the bound column's item in the result. I do this all the time in Access but don't see (remember) how to make it work in EXCEL/VBA.

thanks