Hello
Can anyone help
I was given some code by a kind knowledgable friend that enabled the user in my DB to create a link to a document and place the link in a label on my form
I thought I could use it in another DB and all would work fine. Unfortunately this is not the case and I now get a "compile error" "sub or function not defined" and when I debug the following line is highlighted in yellow
atmpfield = Launchlink([Forms]![Enquriy Form]![CATEGORY WORKS TABLE SUBFORM])
I am a total novice regarding this code and any help, explained in basic terms would be very much appreciated
Thanks
The code is below
Private Sub CREATE_LINK_BUTTON_Click()
Dim atmpfield As String
atmpfield = Launchlink([Forms]![Enquriy Form]![CATEGORY WORKS TABLE SUBFORM])
If atmpfield <> "" Then
[Label1].Caption = atmpfield
[Hyperlink] = atmpfield
[Label1].HyperlinkAddress = [Hyperlink]
Me.Dirty = False
End If
End Sub
Can anyone help
I was given some code by a kind knowledgable friend that enabled the user in my DB to create a link to a document and place the link in a label on my form
I thought I could use it in another DB and all would work fine. Unfortunately this is not the case and I now get a "compile error" "sub or function not defined" and when I debug the following line is highlighted in yellow
atmpfield = Launchlink([Forms]![Enquriy Form]![CATEGORY WORKS TABLE SUBFORM])
I am a total novice regarding this code and any help, explained in basic terms would be very much appreciated
Thanks
The code is below
Private Sub CREATE_LINK_BUTTON_Click()
Dim atmpfield As String
atmpfield = Launchlink([Forms]![Enquriy Form]![CATEGORY WORKS TABLE SUBFORM])
If atmpfield <> "" Then
[Label1].Caption = atmpfield
[Hyperlink] = atmpfield
[Label1].HyperlinkAddress = [Hyperlink]
Me.Dirty = False
End If
End Sub