Minimizing combo dropdown on click

[DanW]

I have a record selecting combo box as the first control on my main form with a dropdown event on Change to help narrow down the record of choice as text is entered into the combo box. Works great if you use the Enter keystroke to finish selecting the record. However, if you use a mouse click, the record is selected and form populated, but you have to click outside of the dropdown to get the dropdown to disappear.



I would like a mouse click on the selected record to also get the dropdown to disappear.

I have tried changing the dropdown event to On Dirty and Before Update, but then I don't even get the dropdown, which works fine on On Change.

Is there code for On Click to minimize the dropdown after selecting the record?

[terryvanduzee]

If I understand right, the combobox remains extended.
You might try to set the focus to another object on the form. In the OnChange or Afterupdate

Me.formobjectname.setfocus

Just a thought.

Terry

[DanW]

Thank you Terry