I have an asp dropdown list that I would like to populate dynamically with two fields. One field should hold 'CourseID', the other, 'Course'. I want the user to select a course by it's description. Then I want to use the dropdown selected CourseID value to pass to a local asp page variable that I will then pass to another asp form for updating a record.

So:

1) How do I load the dropdown with two values from my recordset.
2) How do I retrieve the CourseID value the user selects, using the 'onChange' property.

Thanks if any can help.

Kevin

My working data select statement:
rsStudentClasses.Source = "SELECT C.Course_Id, C.Course_No + ' ' + C.Section + ' ' + C.Area" & _
                    " + ' ' + C.Short_Description AS Course FROM StudentCourseList S " & _
                    " INNER JOIN Course_Info C ON C.Course_Id = S.Course_Id" & _
                    " WHERE S.Student_Id = '" & StudentID & "' ORDER BY Course"

================================================== ============
Current working code to populate the droplown list:

<select name="select" >

<option value="value"

     <%
     If (Not isNull((rsStudentClasses.Fields.Item("Course").Val ue))) Then If ("value" = CStr((rsStudentClasses.Fields.Item("Course").Value ))) Then Response.Write("SELECTED") : Response.Write("")%>>&nbsp;

</option>

<%
 While (NOT rsStudentClasses.EOF)
%>

<option value="<%=rsStudentClasses("Course_Id").Value%>">< %=rsStudentClasses("Course").Value%></option>

<%
     rsStudentClasses.MoveNext()
     Wend

     If (rsStudentClasses.CursorType > 0) Then
          rsStudentClasses.MoveFirst
     Else
          rsStudentClasses.Requery
     End If
%>

</select>

i am working on the same thing.
all i can tell you is that there is no way to do this completely in asp or in javascript. you have to use both.
these links might help

http://www.atgconsulting.com/doublelist.asp
http://www.atgconsulting.com/triplelist.asp
http://www.atgconsulting.com/oodynlistbox.asp
http://www.atgconsulting.com/dotnetlinkedlistbox.aspx
http://www.learnasp.com/learn/subjectdropdowns.asp

this is a really hard yet common problem so if i get a working script, i'll post to this topic.
you can find tons of info on this subject by searching for "dynamically linked listboxes" online.

good luck

-----------------------------------------
Inigo: You have a great gift for rhyme.
Fezzik: Yes, yes, some of the time.
Vizzini: Enough of that.
Inigo: Fezzik, are there rocks ahead?
Fezzik: If there are, we'll all be dead.
Vizzini: No more rhymes now, I mean it!
Fezzik: Anybody want a peanut?

Hii tryntolearn!!
please visit the link

http://p2p.wrox.com/topic.asp?TOPIC_ID=31530

Hope this will help you

Cheers :)

vinod