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

 

[boblarson]

No you can't show more than one column from a combo after selection. Yes, you can set two text boxes to show the selected columns. Set their control sources to be like this:

=[ComboNameHere].[Column](1)

=[ComboNameHere].[Column](2)

That would give you columns 2 and 3 from the combo (zero based).

 

[missinglinq]

In addition to Bob's suggestion, you could use a Query as the RowSource of your Combobox and have a calculated field in it that concatenates the fields you want to display. Using this calculated field as the bound field of the Combobox, the fields would then display after a selection was made. An example would be a field to show first and last names. In the Query Grid this would be done using something like this

CompleteName: [FirstName] & " " & [LastName]

Linq ;0)>