list displaying wrong value

[Bee]

Hi,

I am using a list to display a query. The query has a few fields and one of these fields retreives its values using a look up. The problem is that, when I run it, the value of the look up field displays numbers instead of text.

Any help to fix this problem will be very much appreciated.
B

 

[TanisAgain]

The code you are using would be helpful.

 

[Bee]

The code you are using would be helpful.

Will post the code or better explanation later.

Thank you,
B

 

[NickOrdinParis]

Try this

Make sure in your query, the value comes from the table where the text is and not the table holding the numeric value for the lookup.