Ive created a button that when clicked I want it to return all of the customers that are delinquent for one of the users. The status for delinquent is dlq...and the user is Tom. So when Tom logs in he wants to see all of the dlq records for his accounts only...not for the entire company sales team. How do I do this in VBA. I was able to get the dlq status come up but they were everyone's dlq status accounts. I want them to see their own dlq accounts based on the userid that's logged in.

---

Reply from Alex Hedley:

Create a Query that uses a Parameter.
You'll have to store the User who has logged in either on the MainMenu or use the Environ("Username").
All depends what matches the value you have stored in your Table.
Now you can base the Query on that value.