title: How to get a variable fieldname?
body: <p>I have a record called <code>ouderecord</code> I get from a table with a SQL statement.</p>
  <p>I have this code:</p>
  <pre class="lang-vb prettyprint-override"><code>strSQL = &quot;SELECT * from tblS1lijst where id = &quot; &amp; Keuzelijst3.Column(0)
  Debug.Print strSQL
  ouderecord = CurrentDb.OpenRecordset(strSQL)
  Tmpstr = Mid(Keuzelijst3.Column(2), InStr(1, Keuzelijst3.Column(2), &quot;.&quot;) + 1, _
    Len(Keuzelijst3.Column(2)) - InStr(1, Keuzelijst3.Column(2), &quot;.&quot;) - 1)
  veld_naam = &quot;[&quot; &amp; Tmpstr &amp; &quot;]&quot;
  tekst = &quot;ouderecord!&quot; &amp; veld_naam
  Debug.Print tekst
  </code></pre>
  <p>When I hover over the text (<code>ouderecord![Situatie]</code>) in the Direct window, I see the contents of the field. How do I get that content in a variable?</p>
  <p>I want &quot;Situatie&quot; as a variable.</p>