Specifying the ComboList in the ComboDropDown event

Specifying the ComboList in the ComboDropDown event

Posted by: daniel.ls.howard on 27 December 2020, 12:53 am EST

• 

  daniel.ls.howard

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 December 2020, 12:53 am EST

  Hi All,

  I’m trying to figure out if this is possible. I have a drop down with an unfiltered list of items and I’d like to be able to show the user a filtered list based on clicking the combobox with “alt”-click.

  I thought I could us the ComboDropDown to change the ComboList string but it doesn’t seem to refresh to the filtered list.

  Thanks!

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 27 December 2020, 6:12 pm EST

  Hi,

  You can achieve this in two ways. First using the StartEdit event and second using the ComboDropDown event.

  1: Instead of using ComboDropDown, you need to use StartEdit, since the StartEdit fires before the cell enters edit mode, the changes made to the combo list will be shown in the Combobox. It doesn’t refresh the items if you set the ComboList in combodropdown since the Combobox has already been created and items already added. If you use this method then once the user enters edit mode and opens the Combobox dropdown multiple times while staying in edit mode, the items will stay the same.

  2: If you want to update the items every time the dropdown opens then you can use the ComboDropDown event and add the items manually to the Combobox. Please refer to the samples attached.

  Regards,
  
  Prabhat Sharma.
  
  Proj_DropDown_ComboDropDownEvent.zip
  
  Proj_DropDown_StartEditevent.zip

• 

  daniel.ls.howard

  • Post Options:
  • Link
    Copy

  Posted 27 December 2020, 8:24 pm EST

  Thanks!