Access - Call on click out of Combobox

Question

I've currently got a Form in a 2007 Access Database with a ComboBox where, unless the dropdown is clicked, I don't want it to have focus. This works most of the time, where a user clicks the dropdown and then selects a row, it'll call the AfterUpdate Event, and so I can just change focus through that.

However, my problem is, that when the user opens the ComboBox, doesn't select anything, and clicks to leave. The Dropdown list disappears, but the ComboBox still has focus.

I'm wondering if there's any Event that I'm missing that'll cover this, or any workaround to get this working.

Thanks

Kefash Kefash · Accepted Answer · 2014-06-30T04:59:56

Try setting the event on the form Detail section. Something like

Private Sub Detail_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Me.WhereverYouWant.SetFocus
End Sub

enter image description here

Access - Call on click out of Combobox

1 Answers