I'm trying to use dlookup in this way.

Private Sub newbtn_Click()
Dim winuser As String
Dim supervisorname As String
winuser = GetUserName()
supervisorname = DLookup("SupervisorName", "Supervisors", "windowsuser=" & winuser)
MsgBox (supervisorname)

the msgbox is simply a way to verifiy things are working.  It never executes far enough for that msgbox to come up.  

WHat I get instead is

run-time error '2471'
The expression you entered as a query paramenter produced this error 'carver'

Carver being the username returnd from windows on this one.

It is querying a field called SupervsorName in a table called supervisor and filtering by the field windowsuser"

All field names and table names I've made sure that I'm even using the same case.  

BTW SupervisorName is a calculated field in a table that is linked.  I've also tried this with a query (my original choice to concatenate the first and last name) and received the same error.