Question DLookup stops working in SubReport - why?

[ojeffery]

Hi all,

I'm using a DLookup in a report called Sub Report - Client Extra Fields - it works fine, but when I include it as a subreport in another report, it stops working, just churns out #Error. Any clue why this would be?

Code I'm using is

=DLookUp("[Value]","[Report Query - Value Giver]","[ExtraFieldID] = [Reports]![Sub Report - Client Extra Fields]![ExtraFieldID] ")

Any help would be much appreciated, this is driving me mad!

 

[Lightwave]

Not as knowledbable as some on here but I'll have a go.

I came across something similar where I had a subform on a form where I wanted a certain field to assume a dlookup value which I had referred to in the Default value

Just a guess.

Are you linking the subreport to the report via the field that you wish to use to do a DLookup. I was doing this on a subform not a subreport and naturally it was ignoring it. As the ID field that I was trying to enter was tied back to the header record and could not be manipulated to accept another ID dlookup or otherwise.