How to pass a variable?

Only thing worse than my programming ability is the simple ability to ask the right question!!

Yesterday I got the code to display records from queries from a Access database - thanks!

Now I want to use a form to get a variable and pass that on to select the query to use.

The select code that worked:

strSQL = "SELECT * FROM Bandits order by [6/5/03];"

Now I want to replace Bandits with a variable I select from a dropdown list:

  <FORM>
    <SELECT NAME="Select1" SIZE="1">
    <OPTION VALUE="bandit">Bandits</OPTION>
    <OPTION VALUE="masters">Masters</OPTION>
    <OPTION VALUE="Pro">Pro</OPTION>
    </SELECT>
 <INPUT TYPE="SUBMIT" NAME="Submit1" VALUE="Show Division"></FORM>

I don't understand how to get the variable and then get it in the select string...

Thanks in advance for the help!

And a follow up question..

Would it be better to put the dropdown box on the same page?

If so do you use a form or another method - if I use a form how do I code it to get it in the middle of the asp code? The code I use to display the records is:

Do While not rsevent.EOF
 'Write the HTML to display the current record in the recordset
 Response.Write ("<br>")
 Response.Write (rsevent("Inex")) 

  Response.Write ("&nbsp;&nbsp;&nbsp;")
 Response.Write (rsevent("lastname"))
 Response.Write ("&nbsp;&nbsp;&nbsp;")
 Response.Write (rsevent("division"))
 Response.Write ("&nbsp;&nbsp;&nbsp;")
 Response.Write (rsevent("car"))
 Response.Write ("&nbsp;&nbsp;&nbsp;")
 Response.Write (rsevent("6/5/03")) 

 
 'Move to the next record in the recordset
 rsevent.MoveNext

Loop

Post method is more secure and you can pass more data so use that.

It doesn't have to be the same page you can have the form submit to a completly different page.