combo box populated from a table?

[bookouri]

How can I populate a Combo Box from a table, select a value, and fill in a text field.

some of my selections for the combo box might be retrieved from tables with a large number of rows.

thanks for any info...

 

[FengShui1998]

bookouri,

This should loop through your recordset.

fengshui_1998

<%
Response.write &quot;<select name='dropbox'>&quot;
Do while NOT rs.eof

response.write &quot;<option value='&quot; & rs(&quot;field1&quot & _
&quot;'>&quot; & rs(&quot;field1&quot & &quot;</option>&quot;
rs.movenext

Loop
Response.write &quot;</select>&quot;
%>

 

[bookouri]

thanks, Ill see if I can make it work. I have to figure out how to use a drop down to allow the user to select from a table.. for example an employee ID number, then grab that IDnumber to use as a parameter for something like..

http://www.company.com/employeereport.asp?empid=9998..

is there a better way to do that than with a combo box?

any input would be welcome..