Referencing a text box from another report

[kirnavi]

Does anyone know if I can pull in a value from another report? Report A calculates a value and I name the text box "ValueA". Then in Report B, I need to use ValueA in order to calculate text box "ValueB". I've tried a few different ways (Reports![ReportA]!ValueA) and it keeps giving me the "#Name?" error.

Thanks.

 

[KenReay]

Hi

Reports![ReportA]!ValueA will work ONLY if ReportA is open (Reports! is the collection of Open reports)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK