DB results search form issues

[Martin Stabrey]

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

 

[Stefan B Rusynko]

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!" (-;
_____________________________________________


| 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
|

 

[Martin Stabrey]

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

Mart

 

[Stefan B Rusynko]

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

--




| Thanks Stefan. I get 2, but don't see how 1 helps me.
|
| 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!" (-;
| > _____________________________________________
| >
| >
| > | > | 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
| > |
| >
| >
|