DLookup from a SubReport

[VegaLA]

Hi all,
I am trying to get the value of a field that is displayed on a sub report.
The dlookup field I am using is on the main report and the value I want to pull from is on a subreport.

The code I am using in the field is as follows:-

=DLookUp("txtValue","[subReportName]","txtField02='SomeValue'")

but it keeps coming back as Error.

Can anyone point me in the right direction please?

Mitch....

 

[boblarson]

You don't use a dlookup to get information from a report. You use a DLookup to get information from a table or query.

Here is a good reference for referencing items on a subform/subreport:
http://www.mvps.org/access/forms/frm0031.htm