Simple question on expression building for a form filtered report

[Sajius]

Hello all,

I've only been using access for about a week and gathering reliable solutions and answers from Google searches is spotty at best. On with the question~

Understanding my needs:
I have a textbox I'm using for a layered header on a form filtered report. I'd like the textbox to concatenate two pieces of string data that were used to filter the report like so: Documents for "System fancy numbers and letters" In "Project fancy numbers and letters". It sounded simple enough solution to what I need.



What I have:
In the textbox I have the following expression: =[Reports]![ReportName]![FieldNameForFancyStuff] ...concatenate on similar for the rest. This is generating the Primary key ID of the field data and not the actual data.
ex: Documents for 3 in 9

Any thoughts?

[June7]

If you need descriptive data from lookup table, then need to include that table in the report RecordSource. Then maybe:

="Documents for " & [descriptive field from lookup table] & " In " & [another field]