Guest_imported
New member
- Jan 1, 1970
- 0
I have a combobox that retrieves quote number from database. User can add new quote or select an existing quote. What I need to do is when user drop<br>
down the combobox. We should show two columns. Quote number and Quote description. I don't know how to make combobox display multiple values. Please be aware the combobox only show quote number when it is not droped.<br>
Here is my code.<br>
<br>
<script language="VbScript"><br>
<br>
Sub Window_onload()<br>
<br>
<br>
<% SET RS = ConMaster.Execute("select Quote_number from<br>
quote_master order by quote_number desc"<br>
do while not RS.eof<br>
%><br>
InputForm.QuoteNumber.AddItem <%=RS("Quote_Number"%> <br>
<br>
<%<br>
RS.MoveNext<br>
loop<br>
%> <br>
<br>
<br>
End Sub<br>
<br>
</script><br>
<br>
<br>
<form id="InputForm" name="InputForm" method="get"<br>
action="../QuoteSummary/QuickRFQ.asp"><br>
<br>
<object ID="QuoteNumber" Name="QuoteNumber" WIDTH="96" HEIGHT="24"<br>
CLASSID="CLSID:8BD21D30-EC42-11CE-9E0D-00AA006002F3"><br>
<param NAME="VariousPropertyBits" VALUE="746604571"><br>
<param NAME="DisplayStyle" VALUE="3"><br>
<param NAME="Size" VALUE="2540;635"><br>
<param NAME="MatchEntry" VALUE="1"><br>
<param NAME="ShowDropButtonWhen" VALUE="2"><br>
<param NAME="FontCharSet" VALUE="0"><br>
<param NAME="FontPitchAndFamily" VALUE="2"><br>
<param NAME="FontWeight" VALUE="0"><br>
</object><br>
<br>
</form> <br>
<br>
Any help will be appreciated.<br>
down the combobox. We should show two columns. Quote number and Quote description. I don't know how to make combobox display multiple values. Please be aware the combobox only show quote number when it is not droped.<br>
Here is my code.<br>
<br>
<script language="VbScript"><br>
<br>
Sub Window_onload()<br>
<br>
<br>
<% SET RS = ConMaster.Execute("select Quote_number from<br>
quote_master order by quote_number desc"<br>
do while not RS.eof<br>
%><br>
InputForm.QuoteNumber.AddItem <%=RS("Quote_Number"%> <br>
<br>
<%<br>
RS.MoveNext<br>
loop<br>
%> <br>
<br>
<br>
End Sub<br>
<br>
</script><br>
<br>
<br>
<form id="InputForm" name="InputForm" method="get"<br>
action="../QuoteSummary/QuickRFQ.asp"><br>
<br>
<object ID="QuoteNumber" Name="QuoteNumber" WIDTH="96" HEIGHT="24"<br>
CLASSID="CLSID:8BD21D30-EC42-11CE-9E0D-00AA006002F3"><br>
<param NAME="VariousPropertyBits" VALUE="746604571"><br>
<param NAME="DisplayStyle" VALUE="3"><br>
<param NAME="Size" VALUE="2540;635"><br>
<param NAME="MatchEntry" VALUE="1"><br>
<param NAME="ShowDropButtonWhen" VALUE="2"><br>
<param NAME="FontCharSet" VALUE="0"><br>
<param NAME="FontPitchAndFamily" VALUE="2"><br>
<param NAME="FontWeight" VALUE="0"><br>
</object><br>
<br>
</form> <br>
<br>
Any help will be appreciated.<br>