Referencing a control from another report


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??????????


Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAsked:
Who is Participating?
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.