dlookup in query

[Steely via AccessMonster.com]

I have a query (A) with several fields in it. What I would like to do is use
DLOOKUP to look in to an outside query (Coholotags) that I created which is
not linked to query (A) and look for any text located in the (RECfloy) field
that equals the value in the (Appfloy) field in query (A). I am having
problems with the code below. I have used the same code in a report for the
DLOOKUP function without the Match1: part but cannot seem to get this one to
work in the query The Recfloy and Appfloy fields are text.

Match1: DLookUp("[Recfloy]","[Coholotags]","[Recfloy]='" & [Appfloy] & "'")

Any help would be greatly appreciated.

Steely

 

[Jeff L]

Is there a reason that you don't join the queries together, Appfloy to
Recfloy? That would give you results where the two are equal.