I have a project/task sample database attached. The form frmEmployeeWeeklyInput includes a datasheet of projects and a Select Employee
drop down which filters the projects below. How can I have the Select Employee
drop down also filter the Project
drop down in the datasheet below (only display projects assigned to the user listed in the Select Employee drop down). You can assign employees to projects using the form frmPojectInput.
See attached sample database.