Re: Dropdown Menu Search

["tradmusic.com" <sales@xxxxxxxxxxxxxxxxxxxx>]

How about providing a blank value for the intial value of each drop down? 
If a user doesn't make a selection from any particular drop down/s, then a 
blank value is passed to your results page and the default for that field 
would be selected (%,1,etc).

That's my understanding of how it works anyway.  Might not, neccessarily, be 
correct!

HTH

Regards
Nath.

"Andy" <andy@xxxxxxxx> wrote in message 
news:g6pg7g$eia$1@xxxxxxxxxxxxxxxxxxxxxxxx
> My search page has four dropdown menus.
> If a visitor makes a selection from all four dropdowns, my results page 
> recordset would be easy, select * from table where fieldname1 = dropdown 
> value 1 AND fieldname2 = dropdown value2 AND etc....
> But what if the visitor only makes a selection from two or three of the 
> dropdown menus?
> How would i write the recordet?
> Im using classing ASP, Access 2008 and DW 8
>
> Thanks
> Andy
>