multiple column form field

[boomtap via AccessMonster.com]

I'm building a form and I have one field that has multiple colums looked up
from a query. When I use the drop down list it shows all the columns. When
I've selected a row - it only displays the first column from the row. Is
there a way to display all the columns after it is selected?

 

[Guest]

You'll need to create TextBoxes next to the combo, and use them to display
the other columns.

In the TextBox control source you can write
=[ComboName].Column(1)

The column count start from 0.

 

[boomtap via AccessMonster.com]

Beautiful. Thank you.

You'll need to create TextBoxes next to the combo, and use them to display
the other columns.

In the TextBox control source you can write
=[ComboName].Column(1)

The column count start from 0.

I'm building a form and I have one field that has multiple colums looked up
from a query. When I use the drop down list it shows all the columns. When
I've selected a row - it only displays the first column from the row. Is
there a way to display all the columns after it is selected?