Dynamically setting text box control source or value property

[haydenal]

I have a textbox on a report and have set its control source equal to a value returned by a Dlookup. I run the report and it works fine. I would like to use the value returned in the text box to determine the control source for another text box. I've placed a select case in the print event of the detail section and when I run the report everything is what I expect, except that the values aren't incrimenting with each record in the query. Basically I get a report that lists all my users (so far so good) but each record being returned (other than the user names) are the values in the first record of the query. Where am I going wrong?

 

[Galaxiom]

Not exactly clear here but try this.

Insert a SubReport based on the query.
Set the following properties of the SubReport Control on the Main Report (not in the SubReport Object itself).

Link Master Fields: the name of the LookUp text box in the main report
Link Child Fields: the matching key field in the subreport.