Criteria for DLOOKUP in IF Statement 1

[dmon000]

Hi Everyone,

I have a table called EMAIL_DIST_LIST in which there are two fields, RECEPIENTS and LIST_NAME. I also have function FOSUSERNAME, that returns the logged on user.

I want to write an If statement that tests if the name returned by the function FOSUSERNAME is in the RECEPIENTS field when LIST_NAME = "ECN_ALL_OPERATION".

Thanks for your help!!!

 

[genomon]

Test to see if the returned name = DLookup("RECIPIENTS]","EMAIL_DIST_LIST","LIST_NAME = 'ECN_ALL_OPERATION'")

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[dmon000]

Thanks for the help genomon!

My problem now is getting this to work. I think I should be using "in" instead of "=".

If fOSUserName = DLookup("RECEPIENTS", "EMAIL_DIST_LIST", "LIST_NAME = 'ECN_ALL_OPERATION'")

The Dlookup above returns 3 usernames, so the if statement will be false.

How do I write the conditional to say "If fOSUserName IS IN DLookup("RECEPIENTS", "EMAIL_DIST_LIST", "LIST_NAME = 'ECN_ALL_OPERATION'")

THANKS!!

 

[genomon]

You don't use DLookup if you are looking for "IN".
Another way would be to open a recordset using a WHERE clause
(filter) with the IN clause, and see if the recordcount is > 0.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[genomon]

Duh (wasn't thinking). DCount() with the WHERE clause should do it. If the count > 0 (or 1, or whatever), Then ....

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."