Enter Parameter Value Date

[mast]

I have a report with an unbound text box that requires the user to input a
date when the form is run. This date is usually some date in the future, is
only advisory and is not needed for anything else. Is there any way of
including a 'pop-up calendar' on the 'Enter Parameter value' box to make it
easier for the user to select a date?

 

[Allen Browne]

The parameter dialog is not powerful enough to use calendars, or even combo
boxes.

But you could design a form, and have the query read the date from the form.
This will let you use a popup calendar or combo or activex control or
whatever. In the Criteria row of the query, use and expression such as:
[Forms].[Form1].[Text0]
Provided the form is open, the query will then read the value from the form.

 

[mast]

Thank you Allen. I had already designed the form but thought that if I could
modify the Parameter Dialog it would be a cleaner and more simple method. It
was worth a try.

The parameter dialog is not powerful enough to use calendars, or even combo
boxes.

But you could design a form, and have the query read the date from the form.
This will let you use a popup calendar or combo or activex control or
whatever. In the Criteria row of the query, use and expression such as:
[Forms].[Form1].[Text0]
Provided the form is open, the query will then read the value from the form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a report with an unbound text box that requires the user to input a
date when the form is run. This date is usually some date in the future,
is
only advisory and is not needed for anything else. Is there any way of
including a 'pop-up calendar' on the 'Enter Parameter value' box to make
it
easier for the user to select a date?