Query parameters via form

[DJ]

I'm using the following format in a query criteria box to obtain user input
of a date via a form:

Between [Forms]![daterange]![start] And [Forms]![daterange]![end]

Form name and control names are definitely spelled correctly but all I get
is a standard pop up box requesting

"Enter Parameter Value" for [Forms]![daterange]![start]

Can anyone tell me why it can't recognise my form: daterange

 

[John Spencer]

Is the form open? The form must be open before you open the query.

IF the form is open (as a form - not as a subform) then triple check the names
of the form and the controls on the form.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

 

[DJ]

Yep! That seems to have done it. Many Thanks. I assumed that my form would be
opened for me when I ran the query. I will now open it before I run the query/

Is the form open? The form must be open before you open the query.

IF the form is open (as a form - not as a subform) then triple check the names
of the form and the controls on the form.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

I'm using the following format in a query criteria box to obtain user input
of a date via a form:

Between [Forms]![daterange]![start] And [Forms]![daterange]![end]

Form name and control names are definitely spelled correctly but all I get
is a standard pop up box requesting

"Enter Parameter Value" for [Forms]![daterange]![start]

Can anyone tell me why it can't recognise my form: daterange