Normally in the dropdown items, if the value for each item is not specified,
then the index number is taken as its value even if the display text is
different.
Hence if you have
<SELECT size="1" NAME="SkillType">
<OPTION value="<%=SkillType%>">
<%=SkillType%>
</OPTION>
</SELECT>
This will ensure that each Skill item in the drop down has the same value as
the display text - which is what you want :)
HTH
SPA
"Jim Bo" <Yo*******@yahoo.com> wrote in message
news:Xn*******************************@207.69.154. 205...
Hi,
I have a drop down menu that is being populated by a query to the
access database
---- Code ---
Skill needed
<SELECT size="1" NAME="SkillType" VALUE="SkillType">
<OPTION>
<%=SkillType%>
</option>
</select>
<P>
Gender
<select size="1" name="GenderType">
<option>
<%=GenderType%>
</option>
</select>
</P>
Ethnicity
<select size="1" name="EthnicType">
<option>
<%=EthnicType%>
</option>
</select>
---End Code ----
Now when the values are submitted, I use
Request.Form("EthnicType")
Request.Form("GenderType")
Request.Form("SkillType")
to get the values, but all I get is the option number .. like 1 for Male
and 2 for Female in case of Gender Type. How can I make it, where it would
give me Male or Female instead.. that is .. the value that is selected in
the dropdown menu.
If this is not clear then I can post the whole sricpt .. which is not too
big.
Thanks
JB