Is It Possible To Create Self Calculating Hyperlinks In Access?

I am creating a database that basically holds product information. The different fields I have is Supplier, Product Code, Product Description.

For each product I have a product specification in a word document the names of these specifications follow this convention: [Supplier]&[Product Code] e.g. Coca Cola012345

I need a hyperlink to link to the relevant word document, but rather than going through and setting them up one by one I want the hyperlink to be self calculating depending on the information entered in the fields.

I tried typing in the following in the hyperlink address part in the properties:
=[Supplier]&[Product Code]&".doc"

but it seems to read it exactly as I type it in and obviously does not work.

Can anyone suggest a way round this or perhaps a completely different way of doing it which may be more effective???

Thanks in anticipation of your help.