F4 expand Combo Box

[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

 

[Douglas J. Steele]

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