the next bit...

I have this on search.asp
Code:
<select name="searchtype">
<option value="ClientID">ClientID
<option value="surname">Surname
<option value="age" selected>Age
<option value="Email">Email
</select>
what would you type in search2.asp so that it selects that field, something like this?

SQLString = "SELECT * FROM "' & Request.form("searchtype") & "' WHERE surname ='" & Request.Form("field") & "' ORDER BY clientID ASC "