I need to create queries for my web app that filter records based on the logged in users display name. =UserDisplayName(). I have this value stored in a field in my table as [UserName] but applying that to a criteria in the query design view does nothing. Trying to user userdisplayname() in the query gives me a syntax error. Does anyone know the proper way to query by user name in a web app?
I've googled for this but so far have found nothing. Appreciate any help.