Query parameters via form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DJ - 28 Apr 2008 12:22 GMT

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

Reply to this Message

John Spencer - 28 Apr 2008 12:54 GMT

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:
[quoted text clipped - 7 lines]
>
> Can anyone tell me why it can't recognise my form: daterange

Reply to this Message

DJ - 28 Apr 2008 13:07 GMT

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.
>
[quoted text clipped - 17 lines]
> >
> > Can anyone tell me why it can't recognise my form: daterange

Reply to this Message