I have the following code:
gstrThisUser = Me.txtUser
glngThisEmpID = DLookup("[EmployeeID]", "tblSecurity", _
"[UserID] = " & gstrThisUser)
The issue is this is erroring with the following message:
Run-time error 2471
The expression yu entered as a query parameter produced this error: 'svogel'
I am trying to return the employeeid based on the lookup:
UserID is a string
gstrThisUser is a string
What am I doing wrong?
Thank you
Art Lorenzini
Sioux Falls, Sd
__._,_.___
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar