I have form that has on calendar control that i select the date for two text box that are the start date and end date, the two text boxes (start and end date) are connected to the queries buy a parameter in the Date fields:
Between [Forms]![frmOrderByCustomer]![txtBeginDate] And...