Link to home
Start Free TrialLog in
Avatar of Taras
TarasFlag for Canada

asked on

Filter-Restirct Report to particular user

I have report in Ms Access app that shows data about users usage of office supplies.

Report has several fields: User_Name, Supply_Desc, Date_Out, Date_In, Qty and couple more fields.

I want to show each user when he/she open this report only his info not another user data.

What is the best approach to solve this issue.

Please advise.

Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

You probably have a form with a button that, when clicked, opens the report.
When doing so, specify to filter the report. If the user's ID is found in field UserID, something like this:

DoCmd.OpenReport "YourReportName", acViewNormal, , "UserID = " & Me!UserID.Value & ""

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Neha Nayal
Neha Nayal
Flag of United Arab Emirates image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Taras

ASKER

Thank you so much.