Dynamic Report with Unbound Textbox and Label

[illicited]

I have a form where users select various criteria for generating a report. On the view report command button I have VBA code that generates a dynamic SQL statement and then opens the report based on a querydef with that statement. I have a report structured how I like with an unbound textbox and unbound label in the detail section that I would like to hold the dynamic expression in the SQL statement/QueryDef. I can't seem to get the code right to assign that unbound textbox the results of that particular SQL expression. I've tried in the On Open and On Load events and I'm just not sure what the syntax is for assigning the Thank you in advance for your help.

[orange]

I don't know the answer to your specific question but here is a link related to dynamic reports that may help.

Good luck