SQL string in Textbox

[mderby]

Hi all,

I have a unbound textbox in one of my group footer named TEXT16. The report is base on tbl TM0002

I have a sql string :
=(Select [Description] from TM0050 where (([TM0050].[TYPS])=[Reports]![test roll]![TYPS])
to try to get the description of a TYPE field(integer) from TM0050.

But it seems like I am not getting any the desire result.

Any help will be great.

 

[Rich]

You can't do it that way, use DLookUp, a ComboBox, a subreport or add the field to the reports underlying query

 

[mderby]

Solved

Thanks Rich.

It seems like I had a few option to use.

I have use the DLookup option and it's fine but I guess the whole report become slower. So I think it would be better to include this
field in the report based query.

Thanks again.

mderby