Drop down on combo box with VBA code

  • Thread starter Thread starter Steven R via AccessMonster.com
  • Start date Start date
S

Steven R via AccessMonster.com

I have a combo box that is the 3rd item in the tab order of input on my data
entry form. I also have a command button with coding behind it for the user
to go straight to the combo box for editing. It has code to make the box
drop down, and works perfectly when the user clicks the button. But when
they just go to the combo box during normal input, I wanted the same code in
the On Enter event for the combo box. The cursor goes into the box, but there
are no choices until the user clicks the upside down arrow and invokes the
drop down.

I can't figure out why it works as an on click for the command button, but
doesn't for the On enter event for the combo box.

Private Sub CmdCommCode_Click()

Me.cboCommCode.SetFocus
Me.cboCommCode.Dropdown

End Sub
 
I have a combo box that is the 3rd item in the tab order of input on my data
entry form. I also have a command button with coding behind it for the user
to go straight to the combo box for editing. It has code to make the box
drop down, and works perfectly when the user clicks the button. But when
they just go to the combo box during normal input, I wanted the same code in
the On Enter event for the combo box. The cursor goes into the box, but there
are no choices until the user clicks the upside down arrow and invokes the
drop down.

I can't figure out why it works as an on click for the command button, but
doesn't for the On enter event for the combo box.

Private Sub CmdCommCode_Click()

Me.cboCommCode.SetFocus
Me.cboCommCode.Dropdown

End Sub
Click to expand...

Code the combo Enter event:

Me!cboCommCode.Dropdown

Then all you need in the command button click event is:

Me.cboCommCode.SetFocus

The combo will drop down no matter how you get there,
 
Back
Top