<form name="form2" method="post" action="agency_bookdates.asp">
<input name="agencyid" type="hidden" value="<%=agencyid%>">
<tr bordercolor="#EEEEEE" bgcolor="#006699">
<td colspan="3"><div align="left"><strong>MacKenzie - Agency - Booking Search </strong></div></td>
</tr>
<tr bordercolor="#EEEEEE" bgcolor="#EEEEEE">
<td><div align="right">Search by </div></td>
<td><div align="left">
<%
'response.write "agencyid = " & agencyid & "<br>"
set rst1=con.execute("select * from company where company_id = '" & agencyid & "' and agencyid <> '"&agencyid&"'")
user = rst1("agencyid")
%>
<select name="searchby">
<% Do Until rst1.EOF %>
<option value="<%=trim(rst1("agencyid"))%>"><%=trim(rst1(" company_name"))%></option>
<%
rst1.movenext
loop
%>
</select>
</div></td>
<td> </td>
</tr>
<tr bordercolor="#EEEEEE" bgcolor="#EEEEEE">
<td width="263"><div align="right">Display all bookings that are </div></td>
<td colspan="2"><div align="left">
<input name="timeoption" type="radio" value="current" checked>
Current (Confirmed)</div></td>
</tr>
<tr bordercolor="#EEEEEE" bgcolor="#EEEEEE">
<td><div align="right"></div></td>
<td colspan="2"><div align="left">
<input name="timeoption" type="radio" value="pastdate">
Past Date </div></td>
</tr>
<tr bordercolor="#EEEEEE" bgcolor="#EEEEEE">
<td><div align="right"></div></td>
<td colspan="2"><div align="left">
<input name="timeoption" type="radio" value="option_bookings_only" onClick="location.href='option_agency_bookings.asp '">
Option Bookings </div></td>
</tr>
<% if badlogin3 = "true" then%>
<tr bordercolor="#EEEEEE" bgcolor="#EEEEEE"><td colspan="3">
<div align="center">
Sorry, No Bookings Available!
</div>
</td></tr>
<%else%>
<tr><td></td></tr>
<%end if%>
<tr bordercolor="#EEEEEE" bgcolor="#EEEEEE">
<td> </td>
<td> </td>
<td><div align="right">
<input name="submit" type="submit" title='Click here to search the whole table by requested criteria' onMouseOver='style.cursor="hand"' value="Submit" width="100" height="25">
</div></td>
</tr>
</form>
Thats the whole form.
as you can see the action is set to go to agency_bookdates.asp on submit. which i need. but if the Option Bookings radio button is clicked i need it to go to option_agency_bookings.asp and take the value of <select name="searchby">
www.crmpicco.co.uk