Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can Combobox display multiple values?

Status
Not open for further replies.

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>
&lt;script language=&quot;VbScript&quot;&gt;<br>
<br>
Sub Window_onload()<br>
<br>
<br>
&lt;% SET RS = ConMaster.Execute(&quot;select Quote_number from<br>
quote_master order by quote_number desc&quot;)<br>
do while not RS.eof<br>
%&gt;<br>
InputForm.QuoteNumber.AddItem &lt;%=RS(&quot;Quote_Number&quot;)%&gt; <br>
<br>
&lt;%<br>
RS.MoveNext<br>
loop<br>
%&gt; <br>
<br>
<br>
End Sub<br>
<br>
&lt;/script&gt;<br>
<br>
<br>
&lt;form id=&quot;InputForm&quot; name=&quot;InputForm&quot; method=&quot;get&quot;<br>
action=&quot;../QuoteSummary/QuickRFQ.asp&quot;&gt;<br>
<br>
&lt;object ID=&quot;QuoteNumber&quot; Name=&quot;QuoteNumber&quot; WIDTH=&quot;96&quot; HEIGHT=&quot;24&quot;<br>
CLASSID=&quot;CLSID:8BD21D30-EC42-11CE-9E0D-00AA006002F3&quot;&gt;<br>
&lt;param NAME=&quot;VariousPropertyBits&quot; VALUE=&quot;746604571&quot;&gt;<br>
&lt;param NAME=&quot;DisplayStyle&quot; VALUE=&quot;3&quot;&gt;<br>
&lt;param NAME=&quot;Size&quot; VALUE=&quot;2540;635&quot;&gt;<br>
&lt;param NAME=&quot;MatchEntry&quot; VALUE=&quot;1&quot;&gt;<br>
&lt;param NAME=&quot;ShowDropButtonWhen&quot; VALUE=&quot;2&quot;&gt;<br>
&lt;param NAME=&quot;FontCharSet&quot; VALUE=&quot;0&quot;&gt;<br>
&lt;param NAME=&quot;FontPitchAndFamily&quot; VALUE=&quot;2&quot;&gt;<br>
&lt;param NAME=&quot;FontWeight&quot; VALUE=&quot;0&quot;&gt;<br>
&lt;/object&gt;<br>
<br>
&lt;/form&gt; <br>
<br>
Any help will be appreciated.<br>

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top