I'm looking to filter a report according to the user that opens the report (by command button). I have setup in a data entry form for the DB to capture the logged in username and add it to each record (using a mod I found that uses Environ() ). I've created a report, now I would like for the reports to filter showing only that logged in users data.
I've tried filtering it On Load, On Open, in the properties screen, in VBA, on the query, on the report, I'm just not getting the syntax right
or haven't structured it correctly. I've run across a number of promising suggestions online and on this great site, but they didn't work, a few due to the 64bit version of office I'm running.
Any help/direction is much appreciated.
-About 8 total Users
-The basic module I'm using to get the username is:
Public Function GetUserName() As String
GetUserName = Environ("UserName")