On Tue, 8 Jun 2004 15:58:21 -0400, "Techsupport" wrote:

John, can you tell me what's wrong with this statement?

If IsNull(DLookup("Password", "tblLogin", "[UserName]=" & Me.Username) Then

I get a "Compile Error: Expected: List Separator or )" error message

Thanks

If UserName is a text field you need quotemarks; you also need another
closing paren, they're unmatched. Try


If IsNull(DLookup("Password", "tblLogin", "[UserName]='" & Me.Username
& "'")) Then

Note that if the Username control is empty this will look for a blank
username (and probably find none).

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public