S
SF
Hi,
I am trying to get the Document path from a table through Dlookup. Dlookup
always return null
On Error GoTo Err_btnPrintProject_Click:
Dim DocPath As String
DocPath = DLookup("DocLink", "tblDocuments", "[DocCategory]='Application'
and [DocObjectID]=" & Me.ID)
MsgBox DocPath
Exit_btnPrintProject_Click:
DoCmd.Hourglass False
Exit Sub
Err_btnPrintProject_Click:
If Err.Number = 94 Then
MsgBox "File not found or link has not been set", vbOKOnly +
vbInformation
Else
MsgBox Err.Number, vbOKOnly + vbInformation
End If
Resume Exit_btnPrintProject_Click:
SF
I am trying to get the Document path from a table through Dlookup. Dlookup
always return null
On Error GoTo Err_btnPrintProject_Click:
Dim DocPath As String
DocPath = DLookup("DocLink", "tblDocuments", "[DocCategory]='Application'
and [DocObjectID]=" & Me.ID)
MsgBox DocPath
Exit_btnPrintProject_Click:
DoCmd.Hourglass False
Exit Sub
Err_btnPrintProject_Click:
If Err.Number = 94 Then
MsgBox "File not found or link has not been set", vbOKOnly +
vbInformation
Else
MsgBox Err.Number, vbOKOnly + vbInformation
End If
Resume Exit_btnPrintProject_Click:
SF