Retrieving values from 2 subforms (1 Viewer)

[p595659]

Hi,
I making a query which creates a list of customers in a month. For the start and end dates of the month, they are retrieved from a table and put into 2 seperate subforms. The query isn't working through, so I was wondering if anyone would see where I'm doing wrong.

In the order_date field in the query, I have this as the criteria:
Between [Forms]![sub_fltStart]![DateList_Start] And [Forms]![sub_fltEnd]![DateList_End]

If you want any more clarification then just ask

Cheers,
Ben

EDIT: spelling/grammer

 

[clerics]

may be you lack Main Form 's Name
it 'll be right if it likes:
Between [Forms]![MainFormName]![sub_fltStart]![DateList_Start] And [Forms]![MainFormName]![sub_fltEnd]![DateList_Start]
But make sure both of 2 forms re opening !

 

[p595659]

thanks for the reply,

nope did modify it like you said but still getting 2 parameter boxes coming up for me to enter in the start and end dates.

Ben

EDIT: Problem solved, gave the wrong name of the subform.