Access hyperlink in table through vba

[ETID]

Hi,

I currently have a form that is bound to a table that has a field that is formated as a hyperlink ... well that's all well and good except that I have to go back into the table in design mode and set the hyperlink to a usable target.


How do I get VBA to build a hyperlink target based on user input?

That is to say if the user types in "xyz" ... I want the hyperlink for that field to be set to "n:\zxy.doc"


thanks