combo box selecting

[penfold1992]

Currently when I tab select a combo box, i have to type something in and use the recognition ability to see what options I have.

Is there a way to (once tab selected) use the down arrows to open the box and start selecting options?

 

[John Big Booty]

In the Combo's Got Focus event put;

Me.YourComboName.Dropdown

 

[penfold1992]

thanks this worked exactly how I wanted it.

one question, what is "Me" as a command? what does it actually refer to and is there any cases when i SHOULD or SHOULD NOT use it.

 

[John Big Booty]

Me. let's VBA know that you are referring to a control on the currently active form. Yes I'd use it.

 

[John Big Booty]

In addition when you are in the Code window, as soon as you hit the full stop of the Me. you will get a drop-down list of all the currently relevant commands and controls.