user restricted query

[adidashawn6]

I have a database that I am going to place user-level security. The reports that are going to be available need to be restricted to the user that is logged in and running the report. For example, there is a table that lists the managers and the employees that report directly to these managers. I need the criteria of the query that the report is based on to look at the user information used to log into the database, and use this user information to only pull the direct reports for that manager into the report. Can anyone help with this?

[pbaldy]

If you mean Access built in security,

CurrentUser()

will return the logged in user. You can use that in your criteria.