this thread is a little old so maybe the people that posted it is not around anymore but I'll give a try.
I tried using it for an application that I have and I get the following error message:
and I use the following code:
DLookUp("[MoYr]","tblDCloseCal"," (#" & Str([AsmRDat]) & "#...