title: Trying to concatenate a variable to refer to a field
body: <p>The Variable I want to use will come from the user and is a company name.
  I need to concatenate the string. One field name is "[Amazon Emp Nbr]".</p>
  
  <pre><code>Dim strCompany as String
  MsgBox([Amazon Emp Nbr])' This works! I get the value of the field!
  
  StrCompany = "Amazon"
  MsgBox("[" &amp; strCompany &amp; " Emp Nbr]") 
  </code></pre>
  
  <p>This does not work! It returns the string [Amazon Emp Nbr] Not the value of the field. </p>