Button that will open a dropdown

[henryihunter1954]

Hello;

I need assistance with this situation:

I have a form that I'd like to place a button. The button's sole purpose is to open a drop down (display the contents of the dropdown).

Thanking you in advance.

 

[bob fitz]

The combo box control has a button on the right hand side

 

[henryihunter1954]

Yes. Thank you for replying.

I am aware of that. Because of my design, I have my buttons aligned.
With this entry, I have to use a dropdown menu to get the information.
A button placed atop this dropdown will not confuse the entry person.

As it is now (in testing), the 2 people that tested it felt that they needed to click on the label above the dropdown box.

If I had a button that would open the dropdown, the entry person could make the selection and continue. The entry people are clicking on the label. Nothing happens of course.

Thank you again.

 

[bob fitz]

You would need to set the focus to the combo box before running the command to drop down the combo box. The code for your button would be something like:

Me.YourComboName.SetFocus
Me.YourComboName.Dropdown

Replace "YourComboName" with the actual name of your combo box control.

 

[HiTechCoach]

TIP: F4 is the shortcut toggle open/close of the combo box's drop down list.

TIP2: Use the "On Enter" event to automatically drop down the menu using the this:

Me.ComboBoxControlName.Dropdown