SQL Where clause problem

[farazmit]

I have a sql statement which reads some data from an access database.
for thw where clause I would like to get it's value from one of my forms but I can't use document.form.listname.options[selectedIndex] to access my form in sql where caluse.
How should I perform that.
Here is the code:
Recordset2.Source = "SELECT BusName FROM BusinessInfo WHERE City = '"+ documents.form1.select.options[selectedIndex] +"'";
Thanks

 

[shatch]

The documents.form1... part is client side javascript and the rest is server side. You can use

Recordset2.Source = "SELECT BusName FROM BusinessInfo WHERE City = '"+ request.form("select") +"'" to do the same thing