Subform query" 1

[kpryan]

Hi all,

Could someone look at this query criteria and a solution to a problem
'Between [forms]![form1]![txtStartDate] And [forms]![form1]![txtEndDate]'
This works ok on the main form. It opens a report etc.However if the calendar controls are placed on the subform the query will not work.

Is there a relationship between the main form and subform? which is required in the query?

Many thanks

Ken

 

[maxhugen]

Try this:

Between [forms]![form1]![mySubform].form![txtStartDate] And [forms]![form1]![mySubform].form![txtEndDate]

This references the subform control, and then its 'form' property.

Max Hugen
Australia