Quotes " ' " Hell in Dlookup. 1

[dmon000]

I have a dlookup that just is not right, I'm sure due to the quotes and single quotes not being just right.
This is it:

DLookup("LIST_NAME", "EMAIL_DIST_LIST", "RECEPIENTS Like " & fOSUserName & " & " * " ' AND LIST_NAME = 'ECN_ALL_OPERATION'")

The List_Name and the RECEPIENTS fields are text fields.
fOSUserName is a function which returns a text string which is the currently logged on network user.

THANKS !!!

 

[PWise]

try

DLookup("LIST_NAME", "EMAIL_DIST_LIST", "RECEPIENTS Like '" & fOSUserName & "*' AND LIST_NAME = 'ECN_ALL_OPERATION'")