F4 expand Combo Box

  • Thread starter Thread starter KrisO
  • Start date Start date
K

KrisO

Microsoft Access short cut key F4 opens a combo box to show the available
list - I'm looking for code upon entry into the field (If it is Null) to
automatically do the equivalant of F4 - any help would be appreciated -
Thanks in advance
 
I don't believe it's possible with a macro, but it's trivial in VBA:

Private Sub MyCombo_GotFocus()

If IsNull(Me.MyCombo) Then
Me.MyCombo.DropDown
End If

End Sub
 
Back
Top