Hi<BR>I have a option value list to display depending on username logged in. For example. if username is ABC, then there are 3 locations for it, like location1, location2, location3. So I select * for that username ; then i want to display all the selected locations ; <BR>so I have In my code;<BR>-------<BR><BR>do while not RS.EOF<BR>%><BR><SELECT NAME=cityname> <BR><BR><OPTION VALUE=<%=objRS("location")%>>< %=objRS("fulllocation")%></option><BR> <BR>loop<BR>RS.movenext<BR>-------<BR><BR>Only 1 location is displayed inside the dropdown box. I need to show all the locations associated with that user.<BR><BR>Any ideas??<BR>Thanks<BR>Crystal.