I have a project/task sample database attached. The form frmEmployeeWeeklyInput includes a datasheet of projects and a drop down listing all the employee's. How can I have the drop down requery the datasheet below to just display projects that the user is assigned to?
Please note: More than one user can be assigned to each project see form frmProjectInput.
See attached sample database.