Display description not ID

  • Thread starter Thread starter Whitney
  • Start date Start date
W

Whitney

I've created a form to filter a report based on location. I the report I
created a text box to display the location selected, but it's showing the
location ID, rather than the location name. How can I tell the text box to be
more specific?

Using: =Forms!LocationSelector!Location

The form drop down is programed to display the second column, which has the
name instead of the first column which has the ID.
If there is a better way to do this, please advise.
 
I've created a form to filter a report based on location. I the report I
created a text box to display the location selected, but it's showing the
location ID, rather than the location name. How can I tell the text box to be
more specific?

Using: =Forms!LocationSelector!Location

The form drop down is programed to display the second column, which has the
name instead of the first column which has the ID.
If there is a better way to do this, please advise.
Click to expand...

The form control is probably correctly displaying the bound column of
the Combo Box ... the ID field (because the combo Bound Column
property is set to 1), even though it's displaying the 2nd column's
value.
[Location] is the name of your combo box?
Are both controls on the same LocationSelector form?
Set the text control's control source to:
= [Location].Column(1)
which will display the 2nd column value (Combo's are 0 based).

If they are not both on the same form, use:
=Forms!LocationSelector!Location.Column(1)
 
Back
Top