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!