Transfer Total Field in Report A to Report B

[tiffany]

I created balance statement database. I have a problem to pull total field in Report A and take that total field put it into a text field in Report B.
which it is mean. In the report A, i had text field call txtNetIncome(this field is total all income in balance statement information), so i want the total in txtNetIncome transfer total that amount to Report B. So, how can i do it? here is my coding
txtNetIn=Report![Operation]![txtNetIncome]
but it doesnt work!!
is it because i used simple calculated in Report A that why that field cannot stransfer to another report. Which is my calculated was: in unbound box txtNetIncome i used: =[txtNetAsset]+[txtNetInvest]
Please help me!! Thank you very much..

 

[sonny]

I created balance statement database. I have a problem to pull total field in Report A and take that total field put it into a text field in Report B.
which it is mean. In the report A, i had text field call txtNetIncome(this field is total all income in balance statement information), so i want the total in txtNetIncome transfer total that amount to Report B. So, how can i do it? here is my coding
txtNetIn=Report![Operation]![txtNetIncome]
but it doesnt work!!
is it because i used simple calculated in Report A that why that field cannot stransfer to another report. Which is my calculated was: in unbound box txtNetIncome i used: =[txtNetAsset]+[txtNetInvest]
Please help me!! Thank you very much..

Are both reports open at the same time? I believe they would need to be in order to get the data from one to another....

 

[tiffany]

Are both reports open at the same time? I believe they would need to be in order to get the data from one to another....

No, when the users open the report they will open either one of them first. So, how can i write a code for that??

 

[sonny]

You can open both reports and use the On Activate for the one you want to get the data from have access minimize that report.

 

[tiffany]

You can open both reports and use the On Activate for the one you want to get the data from have access minimize that report.

But my code doesn't work. So, can you tell me give me an sample how it is work? Thanks