Open a document or any file from access

[Guest]

Hi,
The filename is in a field,
When double click on the filename field, I want to open the file/document
How can I do it?

This is my code:

Private Sub fileattach_Click()
Dim filename As String
filename = Me.fileattach
filename = "z:\files\" & filename

End Sub

 

[Allen Browne]

Add:
FollowHyperlink filename