Still getting used to codes and would like a command button to do two things, tick a box and run a command to insert a hyperlink.
I have plenty of separate ones doing these for other things but how do I join the two in one click command?
When the "Email" button is pressed I would like it to mark checkbox "Email2" and to RunCommand acCmdInsertHyperlink for "report" text box.
Two examples of them separate are:
Private Sub Email1_Click()
Me.Email2 = True
End Sub
that sorts out the checkbox
Private Sub Email1_Click()
Me.[report].SetFocus
On Error GoTo browse_stop
RunCommand acCmdInsertHyperlink
browse_stop:
End Sub
does the hyperlink request.
Thanks in advance
I have plenty of separate ones doing these for other things but how do I join the two in one click command?
When the "Email" button is pressed I would like it to mark checkbox "Email2" and to RunCommand acCmdInsertHyperlink for "report" text box.
Two examples of them separate are:
Private Sub Email1_Click()
Me.Email2 = True
End Sub
that sorts out the checkbox
Private Sub Email1_Click()
Me.[report].SetFocus
On Error GoTo browse_stop
RunCommand acCmdInsertHyperlink
browse_stop:
End Sub
does the hyperlink request.
Thanks in advance
Last edited: