menu population

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>