ASP programming : I have text box "ItemId" and "ItemDescription" After I put data in to ItemId and I press Tab (on change event) button, I want to display ItemDescription automatically(this data retrieve from Database).Could you please advise me how to do it .If you have sample source code,that will be great.Thanks

IMO pressing tab is not very intuative. Why not just enter the "itemID" and click a show details button like a regular form? People who are on the wrong side of the digital divide are not aware of the tab button, nor what it does. Additionaly you wouldnt place an onChange event on a input type="text" area. These are commonly used for <select> type form elements. Here is a crazy thought; why not populate a <select> list from the Data base, do you need to enter it manually? This way you can use the onChnage method. You would do something like:


SQL = "SELECT ..."
Set getInfo = Conn.Execute(SQL)

<SELECT NAME="reportType" onChange="Javascript:updateForm.submit();">
<% if not getInfo.EoF then %>
       <option value="0">Select a Group Report</option>
<% do until getInfo.Eof %>
      <option value="<%= getInfo(0) %>"<% if cint(getInfo(0)) = cint(whatReportType) then response.write " selected " end if %>><%= getInfo(1) %></option>
<% getInfo.moveNext
       loop
   else %>
      <option value="0">No report types found</option>
<% end if %>
</SELECT>

Wind is your friend
Matt

I need to enter item id manually.I can not use <select> type because it has too much data to display.Could you please advice.Thanks

There were several questions in my post. Did you see this one?

;;;Why not just enter the "itemID" and click a show details button like a regular form?

Based on my understanding of your requirement this is what I would do. I assume you dont need instruction on how to submit a regular form?

Wind is your friend
Matt