Add all values item to a date field query in a drop down box

[Guest]

I have a drop down box created from a database results wizard that selects
and displays the unique dates in a table. The user is asked to select a date
from that drop down box and that selection is submitted to another database
results wizard to produce a listing of items with that date in it.

I would like to be able to permit the user to select any date by adding an
any value to the drop down box - is this possible?

I can find instructions on how to create this type of wildcard search in
text and numeric fields, but nothing on date fields.

 

[Thomas A. Rowe]

Not possible to allow a user to add content to drop down menu. You would have to add a choice and a
text field for the user to enter their option, then write custom code to process the submission.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[Guest]

Sorry, I didn't make myself clear. I would like to add in a wildcard value
equivalent to % for text fields, the value would be labeled Any and would be
placed in the drop down menu. What I have found is that the % only works for
text fields and I have not be able to find the equivalent for Date fields.

 

[Thomas A. Rowe]

You can place "Any" in your menu, but you then have to have a text field for the user to enter the
date, then in your code, if "Any" is submitted, then use the value for the text field instead of the
"Any" value in the drop drown.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================