Report equilivant for FORM! command 2

[Stevehewitt]

Hey,

I need to display a value that is displayed in a subreport on the master report. I have managed to do this on forms by using the FORM! / FORMS! command as the record source.

Any ideas how I can get this to work in reports?

Thanks,


Steve.

 

[grtammi]

Use the Reports collection instead of the forms collection ... not sure if that'll work on a subreport though.

Reports!YourReport!YourControl.Value

HTH

Greg Tammi, IT Design & Consultation
Work:

http://www.atsbell.com

Home:

http://members.shaw.ca/gregandliz

 

[dhookom]

Use the syntax:
=[srptControlName].[Report].[NameOfControlOnSubreport]


Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Stevehewitt]

Hey guys,

grtammi, I didn't try your suggestion out, but I'll give it ago later. Worth a star though!

dhookom, cheers! Works brilliantly!

Thanks again guys,

Steve.