Dlookup for text from an ID field.

[Banderberg]

I have a report based on a parameter query.
One of the parameters is TM Name.
This parameter value is selected from a list box.
The table on which the query is based also has TM Name as a look-up from a list. So ofcourse the ID is showing in the TM Name field on the report...not the actual name.

I am attempting to use a Dlookup to show the actual name than I will hide the field with the ID. Here's what I have as the control source:

=DLookUp("Name","TM_Names","[TM]=" & [Reports]![Report_TM_Records]![TM])

It is pulling in the value of the first row in the "Name" column of the "TM_Names" table. Doesn't seem to be looking at the value in the TM field on the reports.

My gut feeling is the report needs to be "saved" or "refreshed". I have tried a few macros to do this but I get errors.

What can I do ?

Thanks

 

[Banderberg]

I solved - correct DLookUp =

=DLookUp("[Name]","TM_Names","[TM]=[TM_Names]![ID]")