title: VBA to open MyComputer at a specific folder
body: <p>Ive just inherited an MS Access 2003 system and need a bit of VBA to put behind a command button to open MyComputer at a specific folder to view the files there.
  The folder name will come from a field on a form.
  I did have </p>
  
  <p>Application.FollowHyperLink "C:\" &amp; Me![ref]    (ref is in the format abcd-1234)</p>
  
  <p>when its hard-coded it works fine, but i cant seem to get it to open when picking the foldername up from the form.</p>
  
  <p>any hints? (other than binning access!)
  thanks</p>