I'm not sure this is true since I'm able to call the FundAmt with a textbox in the other report using =[Gifts with appeals not in an Annual Fund (FundType)].[Report]![FundAmt]
I'm not sure this is true since I'm able to call the FundAmt with a textbox in the other report using =[Gifts with appeals not in an Annual Fund (FundType)].[Report]![FundAmt]
if you can do this as you say, then I would assume based on everything else that you have said, that you can do what you need. this entire bit:
Code:
[Gifts with appeals not in an Annual Fund (FundType)].[Report]!
is called an object reference, or pointer. then of course, you are referencing the number after that, that you need:
Code:
[FundAmt]
so, I would assume if you can do that, you can do anything with regard to referencing anything, anywhere, that is open. does that give you enough info to get it done? without really seeing a visual, it's difficult, at least for me, to help out any more. but here's an example => if you want to sum 2 boxes on 2 different reports, but the box that is going to hold the sum is not on either of those reports, I assume, based on what you said, that you could do something like this:
Code:
[textbox 3 on report 3] =
[Gifts with appeals not in an Annual Fund (FundType)].[Report]![FundAmt] +
[Gifts with appeals not in an Annual Fund (FundType)].[Report 2]![FundAmt 2]
if you can do this as you say, then I would assume based on everything else that you have said, that you can do what you need. this entire bit:
Code:
[Gifts with appeals not in an Annual Fund (FundType)].[Report]!
is called an object reference, or pointer. then of course, you are referencing the number after that, that you need:
Code:
[FundAmt]
so, I would assume if you can do that, you can do anything with regard to referencing anything, anywhere, that is open. does that give you enough info to get it done? without really seeing a visual, it's difficult, at least for me, to help out any more. but here's an example => if you want to sum 2 boxes on 2 different reports, but the box that is going to hold the sum is not on either of those reports, I assume, based on what you said, that you could do something like this:
Code:
[textbox 3 on report 3] =
[Gifts with appeals not in an Annual Fund (FundType)].[Report]![FundAmt] +
[Gifts with appeals not in an Annual Fund (FundType)].[Report 2]![FundAmt 2]
@Erin M 2021 - your ability to reference another textbox on a different report will work ONLY if BOTH reports are open simultaneously. Your success thus depends on unusually specific circumstances. You would do better to build a query so that you could use a DLookup or DSum to get the value you wanted.
Obviously what you want to do is working at the moment, but please be aware that you have an unstable solution.
Do you really have an object or control whose name is:
Gifts with appeals not in an Annual Fund (FundType)
?
If so, it might be a good idea to stop now and ensure that object or control names contain no spaces, are shorter, and (maybe, if you find this useful, as many do), prefix it with a few letters indicating what type of control or object it is: frm, tb, cmb, lst, etc.
Spaces in object/control names will begin making your life extremely difficult at some point so best to correct them now, and as for length, I'm all for descriptive (not super short) names, but borderline full sentences is kinda pushing it...
