DLookup using multiple Report Criteria

[tammy23]

I need to lookup an entry in WellLogDetails based on two criteria in Report2 and all three of the following codes return errors....any suggestions?

'a = DLookup("[FileLoc]", "WellLogDetails", "[Well]=Reports!Report2![Well]" And "[ID]=Reports!Report2![ID]")

'a = DLookup("[FileLoc]", "WellLogDetails", "[Well]='" & Reports!Report2![Well] & "' AND [ID]= '" & Reports!Report2![ID] & "'")

a = DLookup("[FileLoc]", "WellLogDetails", "[Well]=[Reports]![Report2]![Well] and [ID]=[Reports]![Report2]![ID]")

 

[SkipVought]

hi,

Please post MS Access questions in one of the many MS Access formums like forum703.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[tammy23]

Thanks...can I move it or should I just repost?