I have a project/task sample database attached. The form frmEmployeeWeeklyInput includes a datasheet of projects and a date picker. How can I have the drop down requery the datasheet below to just display projects for the week of the date selected?
Please note the date picker needs to be friendly with the employee picker above.
The datasheet should requery and only display projects that have a date from Nov 26 to Dec 2 (using WEEKLYDATE).
See attached sample database.