Combo Box Auto Pop-up

[Gary]

Is there a way to make the combo box automatically popup
when the cursor enters that field, rather than having to
click on the arrow to make the list open up?

 

[Cheryl Fischer]

Sure. In the GotFocus event of the combobox control, insert the following:

Me!MyCombo.Dropdown

 

[Gary]

I may be doing something wrong. I click on the field that
has the Combo Box and then click on View and go to Code.
Is this the correct way to get to the Combobox Control? I
then found the field that has the combobox and found
GotFocus but where do I insert that code
(Me!MyCombo.Dropdown) in there? It's a whole page of code
but where does it go?

I appreciate your help. I'm not the best at this type of
code work. Please be patient. You may have to walk me
through, step by step.

 

[Cheryl Fischer]

1. Open the form in Design View
2. Right click on your combo box control
3. When the popup menu appears, select "Properties"
4. When the Properties sheet opens, click the tab labeled "Event"
5. Locate the row labeled "On Got Focus"
6. Click anywhere in the blank space of that row.
7. A downward pointing arrow will appear at the right edge of the row.
Click it.
8. Select Event Procedure
9. Click the little button to the right of the combo box arrow. It has an
ellipsis as its icon (...)
10. Insert the single line of code I provided to you

 

[Guest]

Cheryl,

Thank you so much. It works like a charm.

Gary