multiple column form field

  • Thread starter Thread starter boomtap via AccessMonster.com
  • Start date Start date
B

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?
 
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.
 
Beautiful. Thank you.

Ofer said:
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?
Click to expand...
Click to expand...
 
Back
Top