Access 2003 queries and parameter forms

[daaride]

I have an issue with Access 2003 queries. I am trying to use a form to pass date parameters into the query rather than using the standard prompt . have designed the form and all is in order . but when i put the syntax in the criteria in QBD area , nothing happens ie no form is started. all i get is the usual prompt with the titled with this syntax:

Between [Forms]![frmDateRangeSelecter]![StartDate] And [Forms]![frmDateRangeSelecter]![EndDate]

does the form need to be made global variable or what am i missing?? Please help

 

[DCrake]

The query can only be used if the form is already open in the first instance. If you try to open the query and if finds that the form is not open it will not open the form for you.

Another issue is that this query will remain dedicated to this form and cannot be used by any other forms. So if the query is the underlying recordsource of a report then the form needs to be open as well. If the form is closed it cannot reference the date fields.