Combo Box to Show Multi Column Info After Select
I am using a form which has a combo box with drop down list. Well, I have three columns in my list just as I want and I am having no
trouble getting the correct info by using the bound column
However once I make a selection from the dropped down list the combo
box only displays the item from the first columns. Is there a way to show all three of my items from all three of my columns.
For example, let's say my drop down list shows the following list of
choices each of which come from three columns:
2x4 Spruce fir Borate Treated 24SFBT
2x6 Spruce fir Borate Treated 26SFBT
So, lets say I click select the first item row (2x4 Spruce fir
Borate Treated 24SFBT)
When the combo box updates, the only info it shows to the user is: 2x4
Is there a way to let it show the entire: 2x4 Spruce fir Borate
Treated 24SFBT ????