Filter data between two dates within a Access form

strWhere = „[myfield] Between “ & Format(Me.StartDate, „\#mm\/dd\/yyyy\#) & “ And “ & Format(Me.EndDate, „\#mm\/dd\/yyyy\#“)