Query not working with report

[cp2599]

My parameter query is working fine from the query window when I enter
in the parameters (date and character fields); however, when I have
the parameter form opened with the exact same values entered, the
query doesn't work. I copied the parameters from the where clause of
the query into the debug window of the parameter form and the correct
values appear. Does anyone have any other suggestions on what might
be wrong. I have similar logic working on other parameter forms;
however, this form is the first time I'm using a character field.

 

[Marshall Barton]

My parameter query is working fine from the query window when I enter
in the parameters (date and character fields); however, when I have
the parameter form opened with the exact same values entered, the
query doesn't work. I copied the parameters from the where clause of
the query into the debug window of the parameter form and the correct
values appear. Does anyone have any other suggestions on what might
be wrong. I have similar logic working on other parameter forms;
however, this form is the first time I'm using a character field.

The query parameters must look like:
Forms![name of the form].[name of a parameter text box]
and the form must remain open for the duration of the
query/report.

If you already have that kind of arrangement, first double
check the spelling of the form and text box names. Then
make sure the data types of the text box values agree with
the data types of the table fields.