Dependant Webform Dropdown not filling in and stays greyed out

[bobberuk]

Hi

I have searched and searched everywhere for the answer to this, but have a feeling it is down to the way the webform I am trying to fill out is put together. I can get the VBA to fill the first Dropdown on the webpage, but the second stays greyed out. If I get the page to refresh then the first menu choice reverts to what it was. There is no 'onchange' in the HTML and I can't get 'FireEvent' to work either. But there seems to be an 'optgroup label' in the code that I have never seen before. Any suggestions??


My VBA code has various variables that are collated from data input on excel and to fill the form I use. The 'INCIDENT_RESOLUTION[field_resolution_group_id]' is the first dropdown. 'INCIDENT_RESOLUTION[field_resolution_id]' is the dependant second dropdown.

Please Login or Register  to view this content.

So All the fields fill fine but the 'INCIDENT_RESOLUTION[field_resolution_id]' drop down stays greyed out. Your help will be mucho appreciated.

Thanks

[EduardoHiguchi]

Hello bobberuk, please provide the url of the webpage you want to fill information into.

[bobberuk]

Hi

It's an internal website so you won't be able to access it if I gave you the URL. If it helps I have attached the relevant piece of code as a word document

Thanks

[EduardoHiguchi]

Add this code after your macro fills the first combo box. It should now fill the second combo box with "Battery harness replaced"

Please Login or Register  to view this content.

[EduardoHiguchi]

This is the complete code that works for me.
You will need to reference both Microsoft Internet Controls and Microsoft Shell Controls And Automation libraries

Please Login or Register  to view this content.

[bobberuk]

Thanks for this, I will give it a go today, and let you know how I get on.

[EduardoHiguchi]

Hello bobberuk, i hope you are doing well. Did you try the code? i was wondering if it worked or not. Have a good day!

[bobberuk]

Hi

Sorry it's taken me so long to respond, I have had all sorts of work thrown at me last minute and just haven't had a chance to get on here. The code worked of a sort, and I have now tweaked it and got it to work so thanks very much for your help.