plz help!!!



i want a form in which there is a dropdown menu which pulls a specific 

record from a DB.

there are 3 text boxes other than the drop down menu. if a record is 

selected from the drop down menu the related fields should be displayed in 

the remaing 3 text boxes and the value selected in the dropdown menu 

should not dissappear. Something like 

http://www.autopig.com/searchcriteria.asp



how can i achieve this.



thanks in advance

Try this



<form>

<select name="form1" onChange="document.forms[0].submit();">

<option value="1">1</option>

<option value="2">2</option>

</select>

</form>



<% If Request.Form("form1") <> "" Then %>

<form>

<%

Query

DB.OPen

%>



<select name="form2"onChange="document.forms[1].submit();">

<option value="1">1</option>

<option value="2">2</option>

</select>

</form>

<% End If %>