I have a combo box that receives its rowsource from an update event in another combo box. The sql that is passed to the combo box results in one record that has three fields of data. I need the second field to be displayed. The first field is an ID and I would like that to be hidden. The third field holds a value that I am passing to a text box so it does not need to be displayed.
I know that only one value can be shown at a time in a combo box unless the box is clicked. What I want to have happen is for the second field to display without the user having to click the box at all.
I am trying not to do this with a list box. Is it possible?