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
Any help would be much appreciated, this is driving me mad!
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
Code:
=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!