Submitting a Form with Querystring as action

[Marius]

Hi

I am trying to redirect to a specific page from a button click, after
a user selects an option from a DDLB. I want to then append the
associated value of the selected value to the
action="bannerclicks.asp?ID=" part of the code.
I have tried all the ways I know, but I cannot get it to work, Please
help!

Herewith the relevant code:
<form name="Form1" method="post"
action="Bannerclicks.asp?ID=<%Request.Form("Company")%>">
    <input type="text" name="Company" value="0">
	 <select name="BannerSelect"
onChange="MM_callJS('document.Form1.Company.value=document.Form1.BannerSelect.options[document.Form1.BannerSelect.selectedIndex].value;')">
	 
	 <option value="0" selected>Select a Company</option>
	 <%
While (NOT RSBanners.EOF)
%>
	 <option value="<%=(RSBanners.Fields.Item("ID").Value)%>"><%=(RSBanners.Fields.Item("Company").Value)%></option>
	 <%
  RSBanners.MoveNext()
Wend
If (RSBanners.CursorType > 0) Then
  RSBanners.MoveFirst
Else
  RSBanners.Requery
End If
%>
      </select>
	 <input type="submit" name="Search" value="Search">
	  
    </form>