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)
8/22/2022 - Mon
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!