Filter Records By User
have a database that is keeping track of projects. Each project added is tied to a user and there is getting to be a lot of projects. And if the user logs on and they go to their project screen they only see the projects belonging to themselves. When an administrator wants to view projects by user. They go from main menu screen to a pop up small screen with a drop down box with users listed. They select the user they want and click continue to move to the project screen. I am then trying to filter the projects displayed to the user selected from the previous screen but to no avail.
The other option would to have a drop down box on the project screen that filters the records live.
Which way would be the best way to proceed and how would i go about it??
Whichever option I go with it is the filtering of the records once the user has been selected that I have a problem with.!!
This is the code I was using behind the button once I have selected from the dropdown box.
Thanks in advance