Lets say on page1.asp you have the form below:
<form action="page2.asp" method="post" name="input">
<input type="text" name="postcode" size="4" maxlength="4" /></td>
<select name="membertype">
<option value="1">Accredited Computer Experts</option>
<option value="2">Office Partner Associates</option>
<option value="8">Other Channel Businesses</option>
<option value="">All</option>
</select>
</form>
using the form post method you'll need to send the form to page2.asp
At the top of page2.asp collect the form information into variables with:
<%
strpostcode = request.form("postcode")
strmembertype = request.form("membertype")
%>
next check the information is being passed by printing out the results using:
<%
response.write("strpostcode = " & strpostcode & ", strmembertype = " & strmembertype )
%>
If this works you'll then need to place these variables (strpostcode and strmembertype) in your sql query. As HHI Golf guy says you need to collect the results before you can query the database.