I am expanding an existing form to include more search options. Instead of using a verbose set of nested If/Then statements I am trying to use a single Case statement.

When I post the code I created I get a Server 500 error. Can someone help me straighten out my code?

The idea is: a user can search for a person by name, location, specialty, or age group. The form posts to a 'results' page, and the 'results' page displays their choices.

Here is my 'results' page code:

Response.Write "<p>You searched for: <b>"
Do While Request("Name") <> "" Or Request("Specialty") <> "" Or Request("AgeGroup") <> "" Or Request("Clinic") <> ""
Select Case Request
Case when ("Specialty") <> ""
SpecialtiesRS.Filter = "Id=" & Request("Specialty") & ""
SpecialtySearch = SpecialtiesRS("Specialty")
Case when ("AgeGroup") <> ""
AgeGroupRS.Filter = "Id=" & Request("AgeGroup") & ""
AgegroupSearch = AgeGroupRS("AgeGroup")
Case when ("Clinic") <> ""
ClinicsRS.Filter = "Id=" & Request("Clinic") & ""
ClinicSearch = ClinicsRS("Name")
End Select
Loop
Response.Write "<br>" & Request("Name") & SpecialtySearch & AgegroupSearch & ClinicSearch & "</b>.</p>"

Thanks for any suggestions!

A case statement can only be used for testing multiple values on one variable. It cannot be used with multiple variables. Your stuck with the 'if' statements.

Bummer!

Thanks for the info, Anacrusis.

First of all, don't use <>"", use Length(variable) => 1.

And don't use Loops when you can use FOR TO statements. Always try to narrow down the the options for the If then else statements.

But looking at your results, why not just carry over the form post results? then create a query from these for use in SQL?