help with catching a cancel button

[Guest]

i have some really simple code on a button on my form that adds a hyperlink
to the field that i need it to and this button works for the times when a
user will select something in the dialog and then hits insert. but when a
user clicks cancel it gets a little trickier. how can i modify the code below
to make the cancel not cause an error?

Private Sub btnAddElectricalDiaLink_Click()
Me.ElectricalDiagrams.SetFocus
RunCommand acCmdInsertHyperlink
End Sub

thanks for the help

 

[fredg]

i have some really simple code on a button on my form that adds a hyperlink
to the field that i need it to and this button works for the times when a
user will select something in the dialog and then hits insert. but when a
user clicks cancel it gets a little trickier. how can i modify the code below
to make the cancel not cause an error?

Private Sub btnAddElectricalDiaLink_Click()
Me.ElectricalDiagrams.SetFocus
RunCommand acCmdInsertHyperlink
End Sub

thanks for the help

What is the error #?
Just trap it.

On Error GoTo Err_Handler
Me.ElectricalDiagrams.SetFocus
RunCommand acCmdInsertHyperlink
Exit_Sub:
Exit Sub
Err_Handler:
If err = xxxx Then
Else
MsgBox "Error #: " & Err.Number & " " & Err.Description
End If
Resume Exit_Sub

Replace xxxx with whatever error number is generated.

 

[Guest]

Hello

WOO HOO! My first error trapping code!

thanks for the help, a little tweaking and it worked beautifully for each
button.