I have a report that uses data from a query. In the report header I have a text box that I want to use for the title of my report. I want to use a text box because I want the report title to be dynamic. I would like to have the text box pull a value from results of another query in the same database. I have gone to the text box properties and then control source, from here I am trying to use the expression builder to point to the query and field where the data will reside that I would like for my report title.
The query name is - qryTurnEarnTitle and the field is - Title.
The results of the query will always be one record but it will change based upon the data in the other table.
Please see attached image of what I am trying to do using the expression builder, seems like I have done this in the past successfully. However now when I try and look at the report it shows the box wanting me to enter a parameter value -
Anybody understand what I am trying to do??
The query name is - qryTurnEarnTitle and the field is - Title.
The results of the query will always be one record but it will change based upon the data in the other table.
Please see attached image of what I am trying to do using the expression builder, seems like I have done this in the past successfully. However now when I try and look at the report it shows the box wanting me to enter a parameter value -
Anybody understand what I am trying to do??
Attachments
Last edited:
