using query in a report

When opening my report, I want to be prompted with an input window telling me
to type in the date and shift that I want printed on my report (sort the
information to print only the info from a specific day on the report). I have
figured out how to get these pop up windows to show up by adding the controls
=[DD/MM/YYYY]!Date and =[D or N]!Shift to the corresponding text boxes. The
problem I am encountering is that the values that I specify aren't showing on
the report, instead the textbox contains the value: #error.

What am I doing wrong?

In the Report Header you need two unbound text boxes. Each should say exactly
what the parameter in the query says between the [] with an equal sign in
front as the Contrl Source for the text box like so:

=[DD/MM/YYYY]
=[D or N]

I don't understand your use of !Date or !Shift.

--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Waspfiat" wrote:

When opening my report, I want to be prompted with an input window telling me
to type in the date and shift that I want printed on my report (sort the
information to print only the info from a specific day on the report). I have
figured out how to get these pop up windows to show up by adding the controls
=[DD/MM/YYYY]!Date and =[D or N]!Shift to the corresponding text boxes. The
problem I am encountering is that the values that I specify aren't showing on
the report, instead the textbox contains the value: #error.

What am I doing wrong?