Questions on Control boxes, Parameter queries and calendars in rep

[Guest]

Hi, I am having difficulty with control boxes and parameter queries. I have
created a report that is based on a parameter query. When executing the
report, the user gets prompted 3 different times so they can input an agency,
beginning date, and ending date. The report then brings back all
construction projects being worked by a specific agancy and between certain
dates. However, I would liek the agency box to be a drop down list so the
user can only choose from specific agancies and therefore cannot make a typo
and get no data back because the agency the typed does not match any agencies
in the construction project table, which is what the parameter query is based
on. In addition, I would like the parameter prompts for the beginning and
ending dates to be in a specifc format, such as dd-mmm-yyyy, so if the user
typed mmm dd, yyy they would get a message box stating to renter the date in
the proper format. Ideally, it would be nice for the user to be prompted
with a calendar, or to either be able to type the date or use the calendar.
I have a Dell Optiplex GX 270 with XP and Access 2003. Thanks in advance for
your help.

 

[Bob Howard]

Why not develop a dialog form that you call (as a dialog) in the OnOpen
event of the report?

 

[Guest]

Well, I will have to read about a dialog form as I have never created one.
Thanks for the idea.

Andy