Please all I am trying do is ......a Dependent dropdown box...
Populating itself with datas related to the value of my textbox (x_welljacketID) when the form is opened by the user.
textbox (x_welljacketID) is automatically populated by my database
Welljackdatabase and wellheaddatabase are tables my Database
This what I have so far... please help me out:
<form onSubmit="return EW_checkMyForm(this);" action="welljacketdatabaseedit.asp" method="post">
<p>
<input type="hidden" name="a" value="U">
<input type="hidden" name="key" value="<%= key %>">
<table border="0" cellspacing="1" cellpadding="5" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">WELLJACKETID</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_WELLJACKETID" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_WELLJACKETID&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">WELLID</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><%
strsql = "SELECT * FROM [welljacketdatabase]"
Set rs = Server.CreateObject("ADODB.Recordset"
rs.Open strsql, conn
x_WELLJACKETID = rs("WELLJACKETID"
x_WELLIDList = "<SELECT name='x_WELLID'><OPTION value=''>Please Select</OPTION>"
sqlwrk = "SELECT [WELLID] "
sqlwrk = sqlwrk & "FROM [wellheaddatabase] "
sqlwrk = sqlwrk & "WHERE (1=1) "
If x_WELLJACKETID <> "" Then
sqlwrk = sqlwrk & "AND WELLJACKETID ='"&X_WELLJACKETID&"'"
End If
sqlwrk = sqlwrk & "ORDER BY [WELLID]"
Set rswrk = Server.CreateObject("ADODB.Recordset"
rswrk.Open sqlwrk, conn, 1, 2
If Not rswrk.EOF Then
datawrk = rswrk.GetRows
rowswrk = UBound(datawrk, 2)
For rowcntwrk = 0 To rowswrk
x_WELLIDList = x_WELLIDList & "<OPTION value='" & datawrk(0, rowcntwrk) & "'"
If cstr(datawrk(0, rowcntwrk)&""

= cstr(x_WELLID&""

Then
x_WELLIDList = x_WELLIDList & " selected"
End If
x_WELLIDList = x_WELLIDList & ">" & datawrk(0, rowcntwrk) & "</option>"
Next
End If
rswrk.Close
Set rswrk = Nothing
x_WELLIDList = x_WELLIDList & "</SELECT>"
response.write x_WELLIDList
%>
</font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">SDVTime</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_SDVTime" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_SDVTime&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">SSVTime</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_SSVTime" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_SSVTime&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">SCSSVTime</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_SCSSVTime" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_SCSSVTime&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">PANELSUPPLYPRESSURE</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_PANELSUPPLYPRESSURE" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_PANELSUPPLYPRESSURE&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">SCSSVHOLDINGPRESSURE</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_SCSSVHOLDINGPRESSURE" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_SCSSVHOLDINGPRESSURE&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">ESDTSEHOLDINGPRESSURE</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_ESDTSEHOLDINGPRESSURE" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_ESDTSEHOLDINGPRESSURE&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">DIDESDTRIPINDICATORTURNREDDURINGTEST</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_DIDESDTRIPINDICATORTURNREDDURINGTEST" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_DIDESDTRIPINDICATORTURNREDDURINGTEST&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">DIDRESETRELAYTRIPDURINGTEST</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_DIDRESETRELAYTRIPDURINGTEST" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_DIDRESETRELAYTRIPDURINGTEST&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">WASTSETESTEDDURINGTEST</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_WASTSETESTEDDURINGTEST" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_WASTSETESTEDDURINGTEST&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">ISAGASCONDITIONINGSKIDINSTALLED</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_ISAGASCONDITIONINGSKIDINSTALLED" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_ISAGASCONDITIONINGSKIDINSTALLED&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">AREPANELFACEGUAGESINTHECORRECTRANGEANDFUNCTIONING</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name=" x_AREPANELFACEGUAGESINTHECORRECTRANGEANDFUNCTIONIN
G" size=30 maxlength=50 value="<%= Server. HtmlEncode(x_AREPANELFACEGUAGESINTHECORRECTRANGEAN
DFUNCTIONING&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">OPENANDINSPECTWELLCONTROLPANEL</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_OPENANDINSPECTWELLCONTROLPANEL" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_OPENANDINSPECTWELLCONTROLPANEL&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">ISHYDRAULICOILLEVELOK</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_ISHYDRAULICOILLEVELOK" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_ISHYDRAULICOILLEVELOK&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">ISCONDITIONOFJACKETANDRISEROK</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_ISCONDITIONOFJACKETANDRISEROK" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_ISCONDITIONOFJACKETANDRISEROK&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">ISBOATLOOPINSTALLED</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_ISBOATLOOPINSTALLED" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_ISBOATLOOPINSTALLED&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">ESDSTATIONTESTDATE</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_ESDSTATIONTESTDATE" value="<%= Server.HtmlEncode(x_ESDSTATIONTESTDATE&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">ESDHELLIPORTTESTDATE</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_ESDHELLIPORTTESTDATE" value="<%= Server.HtmlEncode(x_ESDHELLIPORTTESTDATE&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">ESDWELLDECKTESTDATE</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_ESDWELLDECKTESTDATE" value="<%= Server.HtmlEncode(x_ESDWELLDECKTESTDATE&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">TESTDATE</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_TESTDATE" value="<%= Server.HtmlEncode(x_TESTDATE&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">MONTHYEAR</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_MONTHYEAR" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_MONTHYEAR&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">FACILITY</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_FACILITY" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_FACILITY&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">AREA</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_AREA" size=30 maxlength=50 value="<%= Server.HtmlEncode(x_AREA&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">TECHNICIANSNAME</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><input type="text" name="x_TECHNICIANSNAME" size=30 maxlength=99 value="<%= Server.HtmlEncode(x_TECHNICIANSNAME&""

%>"></font> </td>
</tr>
<tr>
<td bgcolor="#0099CC"><font color="#FFFFFF"><font size="-1">COMMENTS</font> </font></td>
<td bgcolor="#F5F5F5"><font size="-1"><textarea cols=35 rows=4 name="x_COMMENTS"><%= x_COMMENTS %></textarea></font> </td>
</tr>
</table>
<p>
<input type="submit" name="Action" value="EDIT">
</form>