To retrieve the recs from the db, the form needs to be posted. Infact, I have tried something of this kind, which wasn't successful.
If u want to use the javascript for this purpose, you have to undergo a lengthy process, like, storing all the rec set values in an array while page loading and getting the appr values from this array thro the javascript, when the selection changes. Again, I don't know how feasible this wld be. May be, any other member might have a solution for this. ILyas -----Original Message----- From: mark wills [mailto:[EMAIL PROTECTED] Sent: Sunday, August 08, 2004 1:13 PM To: [EMAIL PROTECTED] Subject: [ASP] OT: Submit a form when list box changes??? Hi there.... I wonder if anyone can help with this tricky problem.... I have 3 list boxes which are populated by recordsets. However, the records added to the third list box depends on what the user selected in the first and second list boxes. (The values selected in the list boxes are used to 'build' an SQL query in the normal way...) At the moment, I have had to put a submit button next to the SECOND list box, that he/she must click, which causes the form to be POSTed and the query built, thus the third list box can be built with the correct data. However, (and here's my problem!) I need ANOTHER submit button at the bottom of the form, because the page in question is an 'add record' type of form (it's actually an 'add new problem' page to a maintenance database). (sorry... I'll get to the point in a minute!!) So, since I need a form post button to actually submit the form data to the next page for processing, I can't have a submit button for the list box!!! What I need is some clever javascript, that, when the second list box is changed, it causes the form to be submitted to itself. I've seen it on other websites, but don't have a clue how it works... I hate JavaScript almost as much as I hate having no money ;-) Can anyone suggest a solution? Thanks Mark Wills UK http://www.natalie-merchant-online.com --------------------------------- ALL-NEW Yahoo! Messenger - all new features - even more fun! [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
