I have a project/task sample database attached. The form frmEmployeeWeeklyInput includes a datasheet of projects and a Select Employee drop down. How can this drop down control the datasheet input for the employee & filter the records from the tblEmployeeweekyinput table?
-User selects name from Select Employee drop down.
-Users records from the tblEmployeeweekyinput are displayed below in the datasheet (frmEmployeeweeklyinputSub
-When user inputs a new record there name is recorded in the WEEKLYEMID field in the tblEmployeeweeklyinput table.
One of the goals here is for the user not have to select his/her name for each record input.