combo box dropdown

A

Aurora

I am very new at this. I have a combo box on a form that I have dropdown on
entering the box using

Private Sub Combo41_Enter()
Me!Combo41.Dropdown
End Sub

but the problem I have is that it drops the box to the bottom of the screen
instead of directly under the combo box. Can anyone tell me what I am
missing?
 
M

mscertified

I'm not sure why you are doing that.
There is no need to use .dropdown action or the Enter event.

When the user clicks the down arrow the choices will drop down. How far the
list drops down depends on the number of entries and the value of the 'List
Rows' property.

-Dorian
 
A

Aurora

"Why" I am doing that is because staff members do not always click that down
arrow and I need a way to force the box to dropdown when they enter it.

The list drops down 8 entries, but the problem isn't with that it is that
the list of 8 entries actually shows at the bottom of the screen, not under
the combo box.
 
M

mscertified

I tried to reproduce that behaviour and I could not.
When I tried it using the same code as you it worked ok.

-Dorian
 
Top