Page 2 - Dependable combo boxes

Use it like this..

echo "<form name="frmmain" action="".$_SERVER["PHP_SELF"]."" method="post">";

Nothing happens dosent do anything

Without using a submit button you can use bit of JavaScript to do this. You can submit the form for the onChange event of the combo box

<select name="cmb1" onChange="document.frmname.submit();">

I incorporated it in my function in the ie status bar it gives an error on page icon.

Function ExecutableList($Fieldname, $Default) {
//This function responds with a select statement.
//$Restriction is the division the customers belong to. 0 for all
echo(" <select name="$Fieldname"onChange="document.frmname.submit();">n");
echo(" <option value="-1"");
if ($Default == 0) {
echo(" selected");
}
echo(">Please Select Executable</option>n");

ibase_pconnect($_SESSION['dbpath'], $_SESSION['dbuser'], $_SESSION['dbpass']);
$qry = "SELECT EXENO, NAME FROM EXECUTABLES ORDER BY NAME";
$res = ibase_query($qry);
while ($resrow = ibase_fetch_row($res)) {
echo(" <option value="$resrow[0]"");
if ($resrow[0] == $Default) {
echo(" selected");
}
echo(">$resrow[1]</option>n");
}
echo("</select>n");
}

Finally I got it to work thank you nazly for all the help much appreaciated