onchange and asp selection 1

[rotschreck]

Hey all!<br><br>Alrighty, here's the problem:<br><br>There is a drop down box (combo box), that gets it's information from an Access database table, and has an onchange funtion.<br><br>The onchange must select certain entries depending on specific criteria from a table in Access, and allow a second combo box to display these for the user to chose from.<br><br>EX:<br>Type of Fruit: Acidic, Sweet, Tart<br>Color of Fruit:<br><br>If Acidic is chosen then the fields would display:<br>Type of Fruit: Acidic<br>Name of Fruit: Orange, Lemon, Lime<br><br>I've been working on this for a few days now and just can't get anywhere. Any help would be appreciated. <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/siltharin>Rotschrck's

Eclectic Page</a><br>

 

[vinodgk]

Hi,<br><br>for the first form put this code...u have to chk if user is selecting the combo-box..if he is write a javascript code to submit the form like this....<br><br>&lt;script language=&quot;javascript&quot;&gt;<br>&lt;!--<br>function change() <br>{<br> document.forms[0].action = &quot;sss.asp&quot;<br> document.forms[0].submit()<br>}<br>//--&gt;<br>&lt;/script&gt;<br><br><br>and.....<br><br>&lt;form id=&quot;aaa&quot; name=&quot;aaa&quot; method=&quot;post&quot; action=&quot;aaa1.asp&quot;&gt;<br><br><br>&lt;select id=&quot;product&quot; name=&quot;Product&quot; style=&quot;HEIGHT: 22px; WIDTH: 255px&quot; LANGUAGE=&quot;javascript&quot; onchange=&quot;submit()&quot;&gt; <br><br>try this working code ...and if anything more needed contact me at <A HREF="mailto:vinodgk@indya.com">vinodgk@indya.com</A><br><br>Regards<br>Vinod<br>

 

[onetomany]

Try this link.<br><br><A HREF="

http://www.asptoday.com/articles/20000414.htm"

TARGET="_new">

http://www.asptoday.com/articles/20000414.htm</A><br><br><br>This

example is for sql server but the concept should still apply.<br><br>