Referencing a control from another report

Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc used Ask the Experts™

Is it possible to reference a control from say report(1) when on report (2) as long as the report (1) is opened first as hidden? I'm asking this because I need to get the grand total net pay from report(1) for my Journal Voucher as a balancing figure. If yes , then how do I close it??????????


Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017
The better choice would be to use DSum() on the query that report2 uses as its RecordSource.  That way you won't have to open the report.  Remember, reports don't store data, tables store data.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial