Hyperlink into table

[Jarod]

I have a form that is used to add records to a table. A
field(of type hyperlink) in one of those records is a
filename. I want to automatically set this hyperlink. The
path is a set path the type of file is set. I just need
the code to attach the hyperlink to the field keep the
value of the field = filename. I posted this before and
got

Me!filename = C:\made\up\folder\filename.ext

All this line does is put the above text in the field. It
does not attach the hyperlink.

Thank you for your help.

 

[Allen Browne]

Dim strFile As String
strFile = "C:\made\up\folder\filename.ext"
Me!filename = strFile & "#" & strFile & "#"

For an explanation, see:
Introduction to Hyperlink fields
at:
http://allenbrowne.com/casu-09.html