Combo (A2000)

Topic

New Reply

I have a combo on a form which is a look-up.
I want this combo to dropdown if it contains no data.
eg

On Got Focus
If isnull then me.combo?.dropdown
Else
Dont Dropdown.

I’m sure some-one knows how to do this.

Thanks in advance
Dave

Reply | Quote

Replies

You’re almost there:

Private Sub cboSomething_GotFocus()
If IsNull([cboSomething]) Then
[cboSomething].Dropdown
End If
End Sub

Reply | Quote

Perfect Hans
Thanks.
p.s Send my warmest regards to Mrs Hans

Dave

Reply | Quote