Jump to content

Multiple selection - Combo Box


feti

Recommended Posts

Hi Anyone,Plzzzz Help me in thisHow can I create multiple selection in Combo Box??, rit now i created the combo box (only one selection for each list), my problem is, i need the list in the combo box can be selected multiple value, then from the multiple selection in the combo box by users, then it will query out the data from the database based on list selected by users. :) Code: Dim conn - 'Success in connceting into database sIFTemp = sIFTemp & "<TD> : <SELECT NAME='SelectState'>" & vbCrLf sIFTemp = sIFTemp & "<OPTION VALUE='"& sGQDStat&"' selected>" & sGQDStat sIFTemp = sIFTemp & "<OPTION VALUE=''>" & vbCrLf sIFTemp = sIFTemp & fnStateOption() sIFTemp = sIFTemp & "</SELECT></TD></TR><tr>" & vbCrLf******************************************************************sGQDTmpStat= rsDR.Fields("status")sDRMsg = sDRMsg & "<td>" & sGQDTmpStat & " </td>"********************************************************************Function fnStateOption() sGSTTemp = "" sGSTOption = "" sGSTOption = sGSTOption & "<option value='N'>New" sGSTOption = sGSTOption & "<option value='A'>Assigned" sGSTOption = sGSTOption & "<option value='Y'>Analyzed" sGSTOption = sGSTOption & "<option value='I'>Implemented" sGSTOption = sGSTOption & "<option value='V'>Verified" sGSTOption = sGSTOption & "<option value='L'>Validated" sGSTOption = sGSTOption & "<option value='R'>Resolved" sGSTOption = sGSTOption & "<option value='C'>Closed" sGSTOption = sGSTOption & "<option value='R'>Rejected" sGSTOption = sGSTOption & "<option value='D'>Duplicate" sGSTOption = sGSTOption & "<option value='P'>Postponed" sGSTTemp = sGSTTemp & sGSTOption fnStateOption = sGSTTempEnd Function*************************************************************************

Link to comment
Share on other sites

a multi selection combo box looks like this

<select id="cb" multiple="multiple" size="5">  <option value="1">One</option>  <option value="2">Two</option>  <option value="3">Three</option>  <option value="4">Four</option>  <option value="5">Five</option></select>

you hold down CTRL while selecting

Link to comment
Share on other sites

The best way to figure out what happens when people select multiple options is just to print out the value that comes back. Make yourself a multiple select list, select some options, and on the next page print out the result and see what it looks like.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...