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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Update data on DropDown List
- Thread starter QueenP
- Start date
krisbrixon
Programmer
when do you want the data updated?
If while the page is already loaded, then all possible values must be transmitted to the page and then you would use javascript to change the values.
Like the drop downs on this page?:
And I do not use Access so can not help you with the second part of the question.
Kris
- There's never time to do it right, but there's always time to do it over.
If while the page is already loaded, then all possible values must be transmitted to the page and then you would use javascript to change the values.
Like the drop downs on this page?:
And I do not use Access so can not help you with the second part of the question.
Kris
- There's never time to do it right, but there's always time to do it over.
- Thread starter
- #3
krisbrixon
Programmer
you would most likely have to have a seperate textbox to add new items. and then repost the form to save the data and requry the inforamtion to fill in the combobox.
Kris
ACtually this can be done server-side with a text input and a button, to add the value entered in the text input as a new option in the select box and then make it the selected option:
Basically what this is doing is when the function is called you pass it the name of your input and the name of the select box you wish to add the value to. Then it creates a new option object in the options collection for the select box, assigning it to the bottom of the list. Since the index for the options starts at 0 we can assign the new object to the count of the option (elem.options.length) without being worried that it may already have a value, therefore this will work just as well if you are generating your options from ASP. Be forewarned, I just wrote this so it may have adverse side effects in some browsers, I meant it mainly just as an example.
-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
For my next trick I will pull a hat out of a rabbit (if you think thats bad you should see how the pigeon feels...)
Code:
<html>
<head>
<SCRIPT LANGUAGE="JavaScript">
<!--
function addNewOption(txtName,selName){
var optionText;
eval("optionText = yourform."+txtName+".value");
var elem;
eval("elem = yourform."+selName);
elem.options[elem.options.length] = new Option(optionText,optionText);
elem.selectedIndex = elem.options.length - 1;
eval("yourform."+txtName+".value = '';");
}
//-->
</SCRIPT>
</head>
<body>
<form method=POST action="yourpage.asp" name="yourform">
<select name="selColor">
<option value=""> [Select Color] </option>
<option value="red"> Red </option>
<option value="blue"> Blue </option>
<option value="green"> Green </option>
</select>
<input type="button" value="<<" onClick="addNewOption('txtNewColor','selColor');">
<input type="text" name="txtNewColor">
</form>
</body>
</html>Basically what this is doing is when the function is called you pass it the name of your input and the name of the select box you wish to add the value to. Then it creates a new option object in the options collection for the select box, assigning it to the bottom of the list. Since the index for the options starts at 0 we can assign the new object to the count of the option (elem.options.length) without being worried that it may already have a value, therefore this will work just as well if you are generating your options from ASP. Be forewarned, I just wrote this so it may have adverse side effects in some browsers, I meant it mainly just as an example.
-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
For my next trick I will pull a hat out of a rabbit (if you think thats bad you should see how the pigeon feels...)
- Thread starter
- #6
Correction to my previous post, that first server-side should have read client-side, sorry for any confusion,
-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
For my next trick I will pull a hat out of a rabbit (if you think thats bad you should see how the pigeon feels...)
-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
For my next trick I will pull a hat out of a rabbit (if you think thats bad you should see how the pigeon feels...)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question