How to create a List box in Parameter form [message #89853] |
Fri, 06 August 2004 03:22 |
Neeti
Messages: 7 Registered: November 2001
|
Junior Member |
|
|
Hi,
I have a simple requirement. I have a a parameter form in which i need to add a List box for dates, so that the user can select the date from that drop down box. My Question is how do we create a list box in the Parameter form and how do we populate it.
Thanks
|
|
|
Re: How to create a List box in Parameter form [message #89855 is a reply to message #89853] |
Fri, 06 August 2004 06:20 |
Steve
Messages: 190 Registered: September 1999
|
Senior Member |
|
|
Neeti -
To create a listbox in the parameter form:
1) Create your parameter form as you normally would
2) Double click on the parameter entry field in the parameter form to bring up the parameter's properties
3) Open the entry that reads "List of Values"
4) Here you have two options -
a) create a static list that you define yourself
b) write a select statement to populate the
listbox
From the way you describe your situation, I would assume you would write the select statement to populate the list, a la - SELECT date_field from table_name. Good luck!
Regards,
Steve
|
|
|