Combo Box on a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to open the combo box when you enter the
field? Right now I have to click on the arrow drop down
button to display the data in the list. I just want to
enter the field, and display the contents of the combo box.
 
Thank you for you response. I still seem to be having a
problem is there a way I can create a macro to accomplish
this?
 
Thank you for you response. I still seem to be having a
problem is there a way I can create a macro to accomplish
this?
Click to expand...

What problem?
Did you enter the code in the event window or on the event line?

On the Control's On Enter event line write:
[Event Procedure]
Click on the button with the 3 dots that appears on that line.
When the code window opens the cursor will be flashing between 2
already existing lines.
Type:
Me![YourComboName].Dropdown
between those lines.
Change YourComboName to whatever the actual control name is.
Exit the window.

When you then either tab into or click into the combo box, it will
drop down.
 
Back
Top