I am trying to use two date pickers combined with a button in an Access form to filter the query. The two date pickers simply define the range of the dates and the button is to execute the query that's written in SQL. After I hit the button, however, Access still needs me to manually put in the parameter value by showing the "Enter Parameter Value" window.
Can anybody tell me what is wrong with my design or my code?
SELECT Tsheets_Start_Fm_20200829.fname, Tsheets_Start_Fm_20200829.lname, Tsheets_Start_Fm_20200829.local_date, Tsheets_Start_Fm_20200829.jobcode_1, Tsheets_Start_Fm_20200829.jobcode_2, Tsheets_Start_Fm_20200829.billable
FROM Tsheets_Start_Fm_20200829
WHERE (((Tsheets_Start_Fm_20200829.local_date) Between [Forms]![Weekly_Interface]![start_date] And [Forms]![Weekly_Interface]![end_date]));
