drop a DropDown with vba

[somedeadguy]

Hello, I have made a simple data entry form. The goal of the form is speed, and the ability to tab through the form without having to bother using the mouse.

We are using the native autocomplete in 2007 which works well.

The dropdown lists names, id, and address. The names are not unique. The autocomplete will only actually autocomplete one column, and this dropdown has the four columns previously mentioned.

Upon selecting a name that may have a duplicate, the user can press up or down to select the actual record that they are editing, but ONLY after using the mouse to "drop" the dropdown.

I cannot for the life of me find any documentation on a method or property in VBA that will drop the list, so that I can add it to the on_enter event.

Is there such a thing? Or is there any better way to do it?

Thanks.

 

[KenHigg]

I think you just do an 'alt-down arrow'. If telling the users this isn't good enough maybe you can do a send keys with it.

 

[boblarson]

You can get it with

Me.YourComboBox.Dropdown

where Dropdown is actually a method (action) of the combo.

 

[somedeadguy]

That actually works perfect! Was not aware! Thanks!

 

[maxmangion]

you can also try the F4 key.

 

[somedeadguy]

All of these mothods work great. Thanks everyone.

PS

DropDown is a very vague name for that Method, but it works great. Classic Microsoft! I should have noticed the method icon in the smart complete thing. After all of this data entry my eyes are crossing!

Thanks all

 

[KenHigg]

You can get it with

Me.YourComboBox.Dropdown

where Dropdown is actually a method (action) of the combo.

Never used that - Thanks Bob