PKS,
Thanks for getting back to me so promptly!! The data is stored as 2 separate fields in the form SURNAME and FIRSTNAME. The folder name is surname,forename- but i can change it all to surname if that makes it more likely to work.
I could not manage to get the solution you suggested working. Am i suppose to paste this into the hyperlink box, within properties of the button? If so, then no joy as yet. Also, as a newbie, i am assuming that the 'Me' you quote next to surname and forename should be replaced with the name of my form?
Thanks again,
Col
ok, two seperate fields no problem
folder name is surname,forename - is there a space in between? The worry here is if u had two different people with the same name. I would recommened u use a primary key, does your table have a autonumber or something?
say u had a btn called cmdOpen, u then use the click event
e.g.
private sub cmdOpen_Click()
Dim sParentDir as String
Dim sUserDir as String
sParentDir = "C:\me\desktop\" 'best to define this as constant
sUserDir = Me.Surname & "," & Me.Forename 'best to use ID here
FollowHyperlink sParentDir & sUserDir & "\cv.rtf"
end sub
The use of Me means u are going to use a method or property of the form
in this case the two controls that hold the name
type . after Me then u get the intellisense menu
Here u can see your 2 fields
Me.