Calender dates in query

[crug]

I`m using a calender to pick a start date and end date shown in two combo boxes. I can store this value in a table with fields StartDate and EndDate I want the user to be able to pick the dates and show query records between these dates I thought i could use something like - Between"StartDate","tblDate" And" EndDate","tblDate" but it brings a syntax error anyone help ?

 

[FoFa]

Assumptions, chosen dates on a form to match to a single date in a table.
WHERE MyTable.Date2Check BETWEEN Forms!MyForm!Startdate AND Forms!MyForm!Enddate