Display info based on drop-down menu selection

Here is a snip-it from the sub procedure that displays the drop-down list of colors available:

    if objRS.eof then EXIT SUB
   
    response.Write "<select name=""Color_id"">"
   
    while not objRS.eof
   
    response.Write "<option value="""&clng(objRS.fields("Color_id"))&""">"&trim(objRS.fields("Color_value"))&"</option>"
   
    objRS.movenext
    wend
   
    response.Write "</select>"
   



I need to display the available inventory from the database for whatever color is selected in this drop-down menu.  What would be the best way to do this?  Javascript?
LVL 9
AdrienneSperberTech Support CoordinatorAsked:
Who is Participating?
 
Big MontyConnect With a Mentor Senior Web Developer / CEO of ExchangeTree.org Commented:
if you don't want to refresh the page once a selection is made, you'll need to use ajax:

http://api.jquery.com/jQuery.ajax/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.