DLookup()

[jeo]

I have a DLookup Statement for one of my fields:
=DLookUp("[TaskStartDt]","tblDatesonlyPM","[TaskID] = 16")
in this tblDateonlyPM there is also a FK to my Project table - ProjectID.
What I want is to be able to add to this DLookup statement something that will make sure that ProjectID from tblDatesonlyPM is = to ProjectID on my report.
I tried this and it's not working, but I'm not sure how to do this.
=DLookUp("[TaskStartDt]","tblDatesonlyPM","[TaskID] = 16" & "[ProjectID]"="[ProjectID]")

Thanks.

 

[Ukraine82]

Jeo,

Take a look at the link for dlookup help

http://www.mvps.org/access/general/gen0018.htm

hth,
Michael

 

[jeo]

Thanks...this helped!