SendKeys & Dropdown

[wilderfan]

I'd like to get a combo box to drop down automatically AFTER the user SAVES his first combo box selection.

That is, I don't want the dropdown to happen on the first selection.

In the coding for the SAVE button's "on click" even, I set the focus back on the combo box. Then, I was going to use SendKeys "{F4}" to force the combo box to drop down.

But that doesn't seem to be working.


I suppose I could use the Got_Focus event for the combo box, but then I believe the dropdown would happen on the first use of the combo box.

Any suggestions ?

 

[boblarson]

Just use

Me.ComboBoxNameHere.Dropdown

And when you say that the combo saves its first selection, what do you mean? I don't get it.

 

[wilderfan]

Hi, Bob.

I forgot to insert Me. in front of the combo box name - which led me to consider trying SendKeys.

Now that I've inserted Me., it is working the way I wanted.

As for the Save reference, I have a command button next to the combo box to save the selected name from the combo box. The coding for the Save button's on click event includes a question, asking the user if they would like to add additional names to the table. If the user answers "yes", the focus switches back to the combo box and I was hoping to have the dropdown list appear at that point in time.

Thanks for your help.