hello guys.. i am a beginner.. so i totally burr about tis.. so need yout help.. and if possible give me step by step.. the prob is.. I want to create a combo box which load its data automatically when user click the combo box. and the data is retrieve from database SQL, that means, once mouse over the combo box, it will call a function to load the data. If not, the combo box is remain empty.
acctually... i just do whateva my boss need me to do... actually our page sometimes have more than 30 drop down list in one page, so if every drop down request from database, its quite slow... thanks for your advice, but i still need to do it,so, do know how to do it? thnaks
I understand your requirement and as suggested by Ben, AJAX would be the best solution. But, if you do not want to use AJAX, then why not try to sell the concept of Lookup screen?
i.e. instaead of dropdowns, provide the user with a text box. Let user enter some value, or the initial alphabet of the value he/she is looking to select. Provide a link next to your text box as 'Look up' and then based on the value entered by user, retrieve the results in a new screen. User can then select a value from the displayed ones.
This will serve 2 things, 1. user gets refined data - he/she can search 2. you do not need to populate all the drop downs
subject: load data automatically when mouse over the combobox