Formulas in subreports...
I am still not sure I understand your problem, but I will just keep asking questions until I do.
At first thought, it would seem like you could write the results of the computations for "123" and 135 into variables that you could refer to for your YTD Achieved text box. Where are the "123" and 135 calculated?
I might be able to help....
I have quite a bit of experience in Access and Access reports, but I'm not quite sure about all the details involved.
If I'm right, you have 2 queries that feed two different reports that are both subreports on the same main report.
What you must keep in mind about Access and subreports is that there is no way for the subreports to communicate even if they are on the same report. All Access reports are are visual representations of collected data, they dont have all the functionality of, say, an Access Form - only meer translation functionos (math, formatting, etc.)
In order to communicate data from one report to another you need to build the data before the report. Whether you can do this with a simple query or maybe you need to use a module to compute some numbers and populate a table that just stores data to run this report (not a recommended solution, but works in a pinch)
I could be off the mark with my assumptions on your problem, but hope it helps at any rate.