using query in a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Waspfiat - 14 Mar 2006 17:19 GMT

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?

Reply to this Message

Jerry Whittle - 14 Mar 2006 18:18 GMT

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.

Signature

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

> 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
[quoted text clipped - 5 lines]
>
> What am I doing wrong?

Reply to this Message