I table has a field called Attachment, formatted as a Hyperlink.
The field appears on my form with an On Click Event Procedure.
Private Sub Attachment_Click()
If IsNull(Attachment) Then
DoCmd.RunCommand acCmdInsertHyperlink
Else
DoCmd.RunCommand acCmdOpenHyperlink
End If
End Sub...