I am trying to use the button control as follows:
There is a Listbox 1, in which a pull-down menu is incorporated and any
name (CommonName field) can be selected.
I want the btnForm1 to search the specific CommonName and display on a new
window.
However, it's always coming back to the very first record of CommonName.
It will be greatly appreciated if you could look at this problem and
provide me with a solution at your earliest convenience.
 
With best regards,
Hiro Shiratori

<SCRIPT ID=clientEventHandlersVBS LANGUAGE=vbscript>

<!--

Sub btnForm1_OnClick()

window.open "Fish.asp","CommonName",sql = "SELECT Listbox1.CommonName FROM
FishLog ORDER BY Listbox1.CommonName "

End sub

-->

</SCRIPT>