This should be working but I don't see why is not...

[TonyU]

[tt]

I've been looking at this piece of code for about 15 minutes and I can't find where the problem is and why my field is not looping

I need another pair of eyes

<select name=&quot;supervisoremail&quot; size=&quot;1&quot;>
<option value=&quot;supervisoremail&quot;>Your supervisor
email</option>
<%
While (NOT rsDepartments.EOF)
%>
<option value=&quot;<%=(rsDepartments.Fields.Item(&quot;email&quot.Value)%>&quot; ><%=(rsDepartments.Fields.Item(&quot;email&quot.Value)%></option>
<%
rsDepartments.MoveNext()
Wend
If (rsDepartments.CursorType > 0) Then
rsDepartments.MoveFirst
Else
rsDepartments.Requery
End If
%>
</select>

***********************
All I'm getting to display is:

Your supervisor
email

[tt]&quot;A Successful man is one who can build
a firm foundation with the bricks
that others throw at him&quot;
[/tt]

 

[TonyU]

[tt]

I've been working on this way to long. I need a break.
I found the problem. My database was empty.

[tt]&quot;A Successful man is one who can build
a firm foundation with the bricks
that others throw at him&quot;
[/tt]

 

[Tarwn]

Heh, I've never done that before...no, really, why don't you believe me
Sounds like it's coffee break time
-Tarwn The three most dangerous things in the world are a programmer with a soldering iron, a hardware type with a program patch, and a user with an idea
-computer saying (Wiz Biz - Rick Cook)