Hi. I have a project database with tblProject, tblUser and tblCollaborators. In tblCollaborators there is UserID, ProjectID and UserLevel - which will be either admin or Read Only. I want to be able to pull up all the project records that a user is Admin for. Each project can have several Admins who need to edit the project and a user may have Admin access to several projects.
Can this be done from a command button that opens the project form? I thought of doing a query to filter for UserID and Admin level but I'm not sure how to implement it so that the current user is automatically filtered for. ( I do have a login form that will stay open and hidden after the user logs in)