Part of filename from query

[nightflight]

at the moment, the OnClick event procedure for a button is

Private Sub btn_certificate_Click()
Application.FollowHyperlink "C:\<filepath>\FAWR Certificate.doc"
End Sub

There are three different certificate files, EA Certificate, FAW Certificate and FAWR Certificate
What I would like is for the "FAWR" bit to be [qry_certissued]![certtype] as [certtype] is either EA, FAW or FAWR, thus requiring only one button rather than 3.

I've tried

Private Sub btn_certificate_Click()
Application.FollowHyperlink "C:\<filepath>\[qry_certissued]![certtype] Certificate.doc"
End Sub

But get error 490, cannot find file

 

[vbaInet]

Is this what you're talking about?

Application.FollowHyperlink "C:\<filepath>[COLOR=Red]\" &[/COLOR] [certtype][COLOR=Red] & " [/COLOR]Certificate.doc"

 

[nightflight]

That's the one, thanks
=o)

 

[vbaInet]

No problemo!