求写个简单程序
怎样写个函数才能使我选择了部门名称后 可以在员工姓名框中加载该部门的员工姓名???????
<body>
<form method=post id=jb action="asp_submit.asp">
<table border="0" width="100%">
<tr>
<td class="class6"><label for="bumen">部门名称:</label>
<% set res=server.CreateObject ("adodb.recordset")
sql="select bumen from bs_bumen"
res.open sql,session("Connection_String"),3,3
%><select name="bumen" size="1">
<option><%=request("bumen")%></option>
< % do while not res.eof%>
<option value="<%=res("bumen")%>" class="class6"> <%=res ("bumen")% > </option>
<%
res.movenext
loop
res.close
%>
</select>
</td>
</tr>
////////////////////////////////////////
下面这段该怎么改?
<tr>
<td class="class6"><label for="name">员工姓名:</label>
<%dim strDepart
strDepart=Request.querystring("bumen")
set res=server.CreateObject ("adodb.recordset")
sql="select name from bs_name where bumen='" & strDepart & "'"
res.open sql,session("Connection_String"),3,3
%>
<select name="name" size="1">
<% do while not res.eof%>
<option value="<%=res("name")%>" class="class6"><%=res("name")%></option>
<%
res.movenext
loop
res.close
%></select>
</td>
</tr>
//////////////////////////////////////////////////////////////
<p align="center">
<input TYPE="submit" VALUE="提交数据" NAME="B1">
<input TYPE="reset" VALUE="重置数据" NAME="B2"> </p>
</form>
</body>
<script language="vbscript">
sub ok1_onclick()
这里应该怎么写??????????????//
end sub
</script>