user selected date query

[jamin14]

hi

i have a form which allows the user to select two dates . what criteria in the query do i use to select the two dates that the user selected.

so far i have Between [BT214_assessment_09-10]![F_OrdersForperiod]![Date1] And [BT214_assessment_09-10]![F_OrdersForperiod]![Date2]

but this still brings up enter parameter value box which i want to aviod

many thanks

[pbaldy]

The correct syntax to refer to a form control:

Forms Refer to Form and Subform properties and controls

Yours is a little off, and it's unclear whether there's a subform involved.

[jamin14]

Sorry all im doing is entering the dates on the form f_ordersforperiod and using that to run the query but i dnt know what criteria to use in the query to get the dates i collected

thanks

[pbaldy]

I understand. What I'm saying is that:

[BT214_assessment_09-10]![F_OrdersForperiod]![Date1]

is not valid syntax to refer to the form. Either use the Build feature in query design or check out the link for the correct syntax.