Multiple column display on form

[RANCHLAW56]

Is there a way to display multiple columns in a combo box after selection?



I have a combo box which contains 4 columns and displays 3 columns during the selection process but only displays the first visible column when a selection is made.

If it is not possible, is there a way to post the remaining 2 columns into two additional text boxes on the same form?


Access 2007

table consists of : id, statute, description, level

[pbaldy]

No to the first, yes to the second:

=ComboboxName.Column(x)

where x is the number of the column you want to display. Some people add a concatenated column to the combo rowsource to get it to display more than one.