Dlookup not working (1 Viewer)

Locopete99 · Dec 12, 2017

Hi Guys,

I'm missing something here.

Can you take a look at my DLookup and see if you can spot why its erroring?

Error is Runtime 2471

Code:

DLookup("E-mail", "Tbl_User", "[login]=" & "'" & fOSUserName & "'")

Minty · Dec 12, 2017

Your making it too complicated - assuming fOSUserName is text, and doesn't have ' in it

Code:

DLookup("[E-mail]", "Tbl_User", "[login]= '" & fOSUserName & "'")

See the links in my signature.

Locopete99 · Dec 12, 2017

Thanks Minty