CODEWITHSUNDEEP
ms-accessvbams-access-2010
Marchese Il Chihuahua
Marchese Il Chihuahua

Reputation: 1129

Opening a combo box from another object

I would like to know if it is possible to open a combo box and see it's elements listed from another object on the form. I do not like the 'down arrow' on the combo box and would like to create something more 'stylish' if it is possible. I am wondering if there is a routine one could write and put on another object so that upon the 'on click' event, the user will see all the elements listed within the combo box and have the opportunity to select one of them.

Upvotes: 1

Views: 28

Answers (1)

Marek Stejskal
Marek Stejskal

Reputation: 2708

For that you can use the Dropdown method of Combobox object.

Example:

Dim cmb1 As ComboBox: Set cmb1 = Me.Combo1

cmb1.SetFocus ' necessary
cmb1.Dropdown

Note: The control needs to have focus so you have to set it programmatically first.

Upvotes: 1

Related Questions