I want to fill budget code field when the department is selected in the combo box

[moiz20]

I have table departments with three fields DeptID, DepartmentName and budgetcode. Departments value are populated in the dropdown menu. i need to fill the text box of budgetcode when department is selected.

here is code for departmentlist is populated

<select name="Department" id="Department" onChange="showText();">
                <option value="notselected" selected>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</option>
                <%
    set rs1=server.createobject("adodb.recordset")
    DepartmentSQL="Select DeptID,DepartmentName,bcode from departments order by Departmentname"
 
    rs1.open DepartmentSQL,cn,3
 
    while not rs1.eof
                 DepartmentID=rs1("DeptID")
                 DepartmentName=rs1("DepartmentName")
                 bcode=rs1("bcode")
            %>
                <option value="<%=DepartmentName%>"><%=DepartmentName%></option>
                <%rs1.movenext
      wend
 
     %>
              </select>

[Dormilich]

that us usually done through AJAX. you fetch the data by using the selected value and insert the returned data in your output container.

[moiz20]

Can you please write it here to help me out

[Dormilich]

I can help improve your code.

[moiz20]

Please it would be great!

[Dormilich]

show us what you tried.

[moiz20]

The function i am using to fill the value but it is not working.

function showText()
      {
 
        //This functions is used show selected value of listbox into textbox.
         var objselect;
         var txtval;
        objselect=document.forms['form1'].Departments;
 
       //Get the selected value from listbox
        txtval=objselect.options[objselect.selectedIndex].value;
 
       //Display it in textbox 
        document.getElementById('Budget_Code').value = txtval; 
      }

The database is in access
Departments table there are three field. DeptID, DepartmentName and bcode.
Here is the code for department list

<select name="Department" id="Department" onChange="showText();">
                <option value="notselected" selected>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</option>
                <%
    set rs1=server.createobject("adodb.recordset")
    DepartmentSQL="Select DeptID,DepartmentName,bcode from departments order by Departmentname"
 
    rs1.open DepartmentSQL,cn,3
 
    while not rs1.eof
                 DepartmentID=rs1("DeptID")
                 DepartmentName=rs1("DepartmentName")
                 bcode=rs1("bcode")
            %>
                <option value="<%=DepartmentName%>"><%=DepartmentName%></option>
                <%rs1.movenext
      wend
 
     %>
              </select>