Problem with Dropping List Portion of Combo Box

[rdharmar]

I have set-up a combo box to load on the drop down event and the combo box style property is 2- dropdown list.

The problem I'm facing is, the list portion of the combo box does not drop sometimes. There are no errors on loading the combo box and I have Do events in place.

Does anyone have a solution for this. Thanks for your help in advance.

 

[BlackburnKL]

It may be preferrable to load the list prior to the drop-down event. Among other things, this may avoid a delay when trying to see the list (as well as the fact that the list may be unnecessarily loaded multiple times if the user clicks the combobox repeatedly.

However, I also understand that there are times that you need the latest updated information in the list. I also have one that loads the list on the drop-down event. I have also experienced a problem similar to what you have described. In our case, the list opened, but closed again before you could pick an item on it. It was the result of the code called by the drop-down event setting the focus elsewhere. Now don't misunderstand. I didn't say that the code was necessarily in the drop-down event itself, but that it ended up being called by the code in the drop-down event. If you can reproduce when it won't open up, try stepping through the code to see what happens. BlackburnKL

 

[CCLINT]

Do not load it on the click event, but try to load it when the form loads, or with using an event other than one belonging to the combo. [/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[rdharmar]

Thanks! Both your ideas helped me solve. I got rid of loading the combo box on the drop down event.