query with dlookup

[mseifman]

I am trying to run a query to filter records based upon the current user's department. I have the following criteria in my query:

DLookUp("[UserDepartment]","UserList","[LoginID ='" & CurrentUser & "'" ]")

I am receiving the following error:

The expression you entered contains invalid syntax. You omitted an operand or operator, you entered an invalid character or comma, or you entered text without surrounding it in quotation marks.

Can anyone give a hand on this? This Dlookup is new to me, and I've never done this type of query before.

 

[sfreeman@co.mer]

Maybe like this... I haven't tested. [spaces added in statement for clarity]

DLookUp("[UserDepartment]","UserList","[LoginID =' " & CurrentUser & " ' ] " )

HTH

 

[WayneRyan]

ms,

DLookUp("[UserDepartment]", "UserList", "[LoginID] ='" & CurrentUser & "'")

Brackets!

Wayne

 

[mseifman]

Thank you so much it works great