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
==============================================
"Bob" <(E-Mail Removed)> wrote in message
news:7C4B2C3D-1F99-4AA3-8054-(E-Mail Removed)...
> 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" wrote:
>
>> 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
>> ==============================================
>>
>>
>> "Bob" <(E-Mail Removed)> wrote in message
>> news:CD0C95F4-2129-4F80-B981-(E-Mail Removed)...
>> >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.
>>
>>
>>
Similar Threads
