title: Get current record values
body: <p>I'm quite new at programming in Access VBA. </p>
  
  <p>I have a form that shows one record at a time, and I added a button to run a code when you press it. In some part of the code, I need to get the values of the current record (shown in the form).</p>
  
  <p>So, the form I'm working on is "frmProductos", and I want to assign the value of the field "fieldDescripcion" of the current record to 
  "strDescripcion", which is a string type variable. </p>
  
  <p>I tried the following code with no success: (something I found on the internet)</p>
  
  <pre><code>strDescripcion = Forms("frmProductos").CurrentRecord![fieldDescripcion]
  </code></pre>
  
  <p>but I get the Error message</p>
  
  <blockquote>
    <p>Compile error: Qualifier must be collection</p>
  </blockquote>
  
  <p>I don't know if what I tried is close to the correct way to do it, if anyone could guide me I would be very grateful.</p>