I am trying to use:
"txtEmployeeName = '" & Environ("username") & "'"
in the Filter on a form so as to only display the records that have the same user name as the person launching the form. I only want the user to be able to see their own records.
The above code is not working, what am I doing wrong?