feti Posted August 9, 2006 Share Posted August 9, 2006 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 More sharing options...
aspnetguy Posted August 9, 2006 Share Posted August 9, 2006 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 More sharing options...
justsomeguy Posted August 9, 2006 Share Posted August 9, 2006 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 More sharing options...
feti Posted August 14, 2006 Author Share Posted August 14, 2006 Thank you for supportting, i'll try, i'm really appreciate your reply Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now