I am TRYING 2 things here,
1) to have the referred to menu be based on the region menu, ie: if menu region=central then menu referred to is limited to officer_region=central
2) show the first AND last names of officers in the table in the menu referred to

can someone please look at this and make it possible?

<table width="90%" border="1" cellspacing="0" cellpadding="1" bgcolor="#CCCCCC">
<tr>

<td width="20%" bgcolor="#006699"><font color="#FFFFFF"><font face="Tahoma" size="1">Region</font> </font></td> ;

<td width="30%" bgcolor="#F5F5F5"><font face="Tahoma" size="1">
<select name="x_region" size="1">
<%While (NOT rsRegion.EOF)%>
<option value="<%=(rsRegion.Fields.Item("region_name").Value)%> ;"><%=(rsRegion.Fields.Item("region_name").Value)%> </option>
<% rsRegion.MoveNext()
Wend
If (rsRegion.CursorType > 0) Then
rsRegion.MoveFirst
Else
rsRegion.Requery
End If
%>
</select>
</font>
</td>


<td width="25%" bgcolor="#006699"><font color="#FFFFFF"><font face="Tahoma" size="1">Referred to</font> </font></td>

<td width="25%" bgcolor="#F5F5F5"><font face="Tahoma" size="1"> 
<select name="x_referred" size="1">
<%While (NOT rsOfficers.EOF)%>
<option value="<%=(rsOfficers.Fields.Item("last_name").Value) %>"><%=(rsOfficers.Fields.Item("last_name").Value)% ></option>
<%
rsOfficers.MoveNext()
Wend
If (rsOfficers.CursorType > 0) Then
rsOfficers.MoveFirst
Else
rsOfficers.Requery
End If
%>
</select>
</font>
</td>
</tr>
</table>

You gotta program the page to show the refered, first, and last name options based on the querystring, ie. if you name your page page.asp then program it so that page.asp?region=central will display the options (refered, first, and last name) only for central region, then make the region drop-down menu redirect you to page.asp?region=central when you select central, etc...

There MIGHT be a way to do it with JavaScript without having to refresh but if there is one I don't know how to do it