Let me try if it is working. Could u help me with the question on Auto completion of text.(That's my wife's question) We have a search form with name field when a person tries to type a name it should autocomplete it by taking the most matching field from a database table.
Autocomplete would have to happen on the client's machine so it implies that all of the names would have to be downloaded to the browser (unless you post the form between keystrokes!). Then you would need client-side code to search for the nearest match and complete the text, as they typed. I could imagine you could download the names in a hidden text field and write a lot of code to search it, but it would be difficult to do it and keep it compatible..<BR><BR>There is a built-in autocomplete for IE forms as an option in the Options menu, but it would autocomplete with the last entry attempted. Maybe the clients would settle for that?<BR><BR>Another option would be to use <select> tags so at least as they type the first letter it selects the first entry beginning with the letter. Typing 'S' multiple times would take you through the S's. But I don't know if that's what they need, if they are searching for something that might not be there...<BR><BR>Anyone else?
The table i am using has 2 fields (deptID and DeptName) The DeptNames should come in the list box and value for each item in the listbox should be the corresponding DeptID no. How do i put the value for each choice in the list box?<BR>
You could use the deptID as the value and DeptName as the displayed text. When the page is posted, the Request would just contain the chosen deptID.<BR><BR>Response.Write "<select name=selMenu>"<BR>Do While Not oRS.EOF<BR>  Response.Write "<option value='" & Trim(oRS("deptID")) & "'>" & _<BR>    Trim(oRS("DeptName")) & _<BR>    "</option>"<BR>Loop<BR>Response.Write "</select>"