Experts, The below Dlookup works but I need to tweek it to show the [AgtType] i/o the [TypeID]....(ie: its showing a number i/o the name). I think I need column(1) on [Type_Agt] but not sure how to do this. I put [Type_Agt].column(1) but that gives me an error.
i have this is in the query design grid of the report:
JV/Consort: DLookUp("[Type_Agt]","tblAgreements_thisPrj","ProjID= " & [Projects.ID])
[Type_Agt] has a row source of : SELECT tblAgreements_Type_DropBox.TypeID, tblAgreements_Type_DropBox.AgtType FROM tblAgreements_Type_DropBox ORDER BY tblAgreements_Type_DropBox.AgtType;