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...