i cannot get the values of the database to populate based on the selection from the drop down. I have posted some of the code i am using to get the results i am looking for. <SELECT size=10 name=VehicleList onchange="document.frmUsedCars.submit()">
<OPTION>--------------------------------------------- New Listing ---------------------------------------------</OPTION>
<%If Not rsData.BOF Then rsData.MoveFirst
Do Until rsData.EOF%>
<option value="<%=rsData.Fields("CarID")%>"><%=rsData.Fields("Make")%></option>
<%rsData.MoveNext
Loop%>
</SELECT>
<font face=arial size=2>Make</font>&nbsp;<INPUT type="text" name="Make" value=<%if selected then Response.Write("value='" & rsData.Fields("Make") & "'") end if%>>>....this is the code i am using to get the value to populate. where am i making my mistake?