title: MS Access VBA - extract listbox value on a form (using form name.)
body: <p>This seemed to be working but just stopped and I'm not sure what I changed to cause this. </p>
  
  <p>I have a listbox on a form. (a single select listbox).</p>
  
  <p>To extract the value, I can do <code>me.listboxName.Column(0)</code> and that works perfectly.</p>
  
  <p>However, that's not the code I want to use. (as I will reference it from another form )</p>
  
  <pre><code>Form_myformName.listboxName.Column(0)
  </code></pre>
  
  <p>is what I had, and it worked and now it's stopped. It still works for similar code on other forms, so I'm not sure what's happened.</p>
  
  <p>If I type in <code>me.name</code>, it tells me correctly that my form name is "myFormName". 
  If I type in <code>Form_myFormName</code>., it prompts me with the name of my list box so I know I have the names correct. However, if I try to extract the value using:</p>
  
  <pre><code> Form_myformName.listboxName.Column(0)
  </code></pre>
  
  <p>it gives me a value of <code>Null</code>, despite the listbox having a selected value. (which I can sucessfully extract by using me.listboxname etc)</p>
  
  <p>hopefully that makes sense. anyone know what I'm doing wrong? </p>