Hi all,

My problem two-fold:

First - two (of five) fields specified in my Search Form should be drop-down
lists (of pre-defined choices - as used in the Access DB). The default
creates a text box only. How can I get a drop-down list to be used, possibly
directly from the DB in the Search Form?

Second - as mentioned, the above search form has 5 fields, 3 three are
simple text fields, 2 are drop-down lists. I'd like the returned results to
reflect a match from any 1 of the 5 choices - it doesn't matter which. I've
managed to succeed with the 3 text fields by using "contains" in the search
criteria, but how would I manage this with the drop-down lists. I would
ideally like the first option of the drop-down lists to be a blank wildcard
(or something equivalent), so that unless it is actually selected, it won't
affect what's been chosen in the text fields. Possible?

TIA

Mart

1) See http://www.asp101.com/samples/db_pulldown_linked.asp for the drop downs

2) Use an OR between your criteria for each search field
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


"Martin Stabrey" <(E-Mail Removed)> wrote in message news:1B5A7D3D-034B-47B4-8EE0-(E-Mail Removed)...
| Hi all,
|
| My problem two-fold:
|
| First - two (of five) fields specified in my Search Form should be drop-down
| lists (of pre-defined choices - as used in the Access DB). The default
| creates a text box only. How can I get a drop-down list to be used, possibly
| directly from the DB in the Search Form?
|
| Second - as mentioned, the above search form has 5 fields, 3 three are
| simple text fields, 2 are drop-down lists. I'd like the returned results to
| reflect a match from any 1 of the 5 choices - it doesn't matter which. I've
| managed to succeed with the 3 text fields by using "contains" in the search
| criteria, but how would I manage this with the drop-down lists. I would
| ideally like the first option of the drop-down lists to be a blank wildcard
| (or something equivalent), so that unless it is actually selected, it won't
| affect what's been chosen in the text fields. Possible?
|
| TIA
|
| Mart
|

Thanks Stefan. I get 2, but don't see how 1 helps me.

Mart
"Stefan B Rusynko" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 1) See http://www.asp101.com/samples/db_pulldown_linked.asp for the drop
> downs
>
> 2) Use an OR between your criteria for each search field
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> _____________________________________________
>
>
> "Martin Stabrey" <(E-Mail Removed)> wrote in message
> news:1B5A7D3D-034B-47B4-8EE0-(E-Mail Removed)...
> | Hi all,
> |
> | My problem two-fold:
> |
> | First - two (of five) fields specified in my Search Form should be
> drop-down
> | lists (of pre-defined choices - as used in the Access DB). The default
> | creates a text box only. How can I get a drop-down list to be used,
> possibly
> | directly from the DB in the Search Form?
> |
> | Second - as mentioned, the above search form has 5 fields, 3 three are
> | simple text fields, 2 are drop-down lists. I'd like the returned results
> to
> | reflect a match from any 1 of the 5 choices - it doesn't matter which.
> I've
> | managed to succeed with the 3 text fields by using "contains" in the
> search
> | criteria, but how would I manage this with the drop-down lists. I would
> | ideally like the first option of the drop-down lists to be a blank
> wildcard
> | (or something equivalent), so that unless it is actually selected, it
> won't
> | affect what's been chosen in the text fields. Possible?
> |
> | TIA
> |
> | Mart
> |
>
>

1 shows you how to create dropdowns (and linked dropdowns from a database)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Martin Stabrey" <(E-Mail Removed)> wrote in message news:1953AC5F-BC63-4FFA-9E9C-(E-Mail Removed)...
| Thanks Stefan. I get 2, but don't see how 1 helps me.
|
| Mart
| "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
| news:(E-Mail Removed)...
| > 1) See http://www.asp101.com/samples/db_pulldown_linked.asp for the drop
| > downs
| >
| > 2) Use an OR between your criteria for each search field
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > "Martin Stabrey" <(E-Mail Removed)> wrote in message
| > news:1B5A7D3D-034B-47B4-8EE0-(E-Mail Removed)...
| > | Hi all,
| > |
| > | My problem two-fold:
| > |
| > | First - two (of five) fields specified in my Search Form should be
| > drop-down
| > | lists (of pre-defined choices - as used in the Access DB). The default
| > | creates a text box only. How can I get a drop-down list to be used,
| > possibly
| > | directly from the DB in the Search Form?
| > |
| > | Second - as mentioned, the above search form has 5 fields, 3 three are
| > | simple text fields, 2 are drop-down lists. I'd like the returned results
| > to
| > | reflect a match from any 1 of the 5 choices - it doesn't matter which.
| > I've
| > | managed to succeed with the 3 text fields by using "contains" in the
| > search
| > | criteria, but how would I manage this with the drop-down lists. I would
| > | ideally like the first option of the drop-down lists to be a blank
| > wildcard
| > | (or something equivalent), so that unless it is actually selected, it
| > won't
| > | affect what's been chosen in the text fields. Possible?
| > |
| > | TIA
| > |
| > | Mart
| > |
| >
| >
|