i have to make a search form in asp that has multiple criteria (Location, File Type, Month, Year) all in dropdown boxes.

right now all i have is the html part (with a little asp to make the year part of it dynamic) and i need help with the asp. any help would be appreciated!


soooo.. this is what i have:

Code:
<body>

           <table border="1" cellpadding="2" cellspacing="0" 
           style="border-collapse: collapse" bordercolor="#111111" width="396" height="162">
             <tr>
               <td width="388" bgcolor="#CF0707" colspan="2" height="19">
               <b><font face="Arial" color="#FFFFFF">Search Files</font></b></td>
             </tr>
             
             
             <tr>
               <td width="126" height="22"> <b><font face="Arial" size="2">Location:</font></b></td>
               <td width="257" height="22"> <font face="Arial"> <b>
               <font size="2"><select size="1" name="Location">
               <option>Location</option>
               <option value="Southern California">Southern California</option>
               <option value="Northern California">Northern California</option>
               <option value="Arizona &amp; Nevada">Arizona & Nevada</option>        			                 
   			 </select></font></td>
             </tr>
             
             
             <tr>
               <td width="126" height="22"> <b><font face="Arial" size="2">Type:</font></b></td>
               <td width="257" height="22"> <font face="Arial"> <b>
               <font size="2"><select size="1" name="FileType">
               <option>Type</option>   
               <option value="Additions">Additions</option>
               <option value="Deletions">Deletions</option>
               <option value="Changes">Changes</option>                       
               </select></font></td>
             </tr>
             
             
             <tr>
               <td width="126" height="22"> <b><font face="Arial" size="2">Month:</font></b></td>
               <td width="257" height="22"> <font face="Arial"> <b>
               <font size="2"><select size="1" name="DateMonth">
               <option>Month</option>              
               <option value="January">January</option>
               <option value="February">February</option>
               <option value="March">March</option>
               <option value="April">April</option>
               <option value="May">May</option>
               <option value="June">June</option>
               <option value="July">July</option>
               <option value="August">August</option>
               <option value="September">September</option>
               <option value="October">October</option>
               <option value="November">November</option>
               <option value="December">December</option>                 
               </select></font></td>
             </tr>
             
             
             <tr>
               <td width="126" height="22"> <b><font face="Arial" size="2">Year:</font></b></td>
               <td width="257" height="22"> <select size="1" name="DateYear">
		    	<option>Year</option> 		   
					<% DIM intYearCounter, intCurrentYear %>
					<% intCurrentYear = Year(Date - 365) %>
					<% FOR intYearCounter = intCurrentYear TO (intCurrentYear + 5) %>
					<% Response.Write "<OPTION>" & CStr(intYearCounter) & "</OPTION>" %>
					<% NEXT %>				
			 </select></td>
             </tr>
             

             <tr>
               <td width="388" align="center" colspan="2" height="26">
               <input type="submit" value="Search" name="Search"></td>
             </tr>
           </table>
         
</body>