strvalue=<get the value of the combo>;
"style" is a HTML attribute. I'd be very careful about calling HTML elements "style". Especially if it doesn't have quotes around it. Lets's call it "selStyle" instead, and give it an ID.
<select name=style onchange='fngetvalue()'>
<select name='selStyle' id='selStyle' onchange='fngetvalue()'>
strvalue = document.getElementById('selStyle').options[document.getElementById('selStyle').selectedIndex].value;
Now... the ASP is set up so that it looks to see if those variables are present:
And if they are, it fires a second request to the database, to populate the second dropdown. And here we find another problem:
if action ="loadcombo2" then
You populate this variable, "style", right near the top of the page:
where proptype='" & style &"'
But style isn't passed in the QueryString. The only variables that might be in the QueryString are "action" and "value". If you've changed the name of your combo box like I said, you'll be able to get it by going:
but if you've been paying attention you'll know that this value will be exactly the same as the value you got in the now-confusingly-named QueryString variable "Value". So you may as well stop mucking about with the form and use the value that you've already got:
style = Request.Form("selStyle")
Hope that helps....
where proptype='" & value &"'