Custom Form to supply parameters to a query/report

[Olu Solaru]

I created a custom form to supply parameters. The custom form works but when
I run the query, it is not giving me the correct captions on the form. It
lists the entire object, just as it is listed in the QBE window

Example:
Between [Forms]![Employees Listed by Control Number within Date
Range]![StartDate] And [Forms]![Employees Listed by Control Number within
Date Range]![EndDate]

I was expecting a simple - StartDate and EndDate parameter.

What am I doing wrong here?

 

[SusanV]

For date fields you need to enclose the date in hashmarks. Try:

Example:
Between #[Forms]![Employees Listed by Control Number within Date
Range]![StartDate]# And #[Forms]![Employees Listed by Control Number within
Date Range]![EndDate]#

 

[Olu Solaru]

Didn't work, tells me date expression is not valid. I actually have another
parameter that is giving me the same problems. All the parameters are in a
custom form.
ControlNumber: - Combo Box
Start Date:
End Date:
My problem is that the Custom form (Dialog box) does not appear with the
three controls when I run my query.

For date fields you need to enclose the date in hashmarks. Try:

Example:
Between #[Forms]![Employees Listed by Control Number within Date
Range]![StartDate]# And #[Forms]![Employees Listed by Control Number within
Date Range]![EndDate]#

--
hth,
SusanV

I created a custom form to supply parameters. The custom form works but
when
I run the query, it is not giving me the correct captions on the form. It
lists the entire object, just as it is listed in the QBE window

Example:
Between [Forms]![Employees Listed by Control Number within Date
Range]![StartDate] And [Forms]![Employees Listed by Control Number within
Date Range]![EndDate]

I was expecting a simple - StartDate and EndDate parameter.

What am I doing wrong here?