title: VBA Access getting RowSource to find lookup values
body: <p>VBA noob here (as of this mourning),</p>
  
  <p>In MS Access I wrote a test function to find the value of a record base on some criteria you pass in.</p>
  
  <p>The function seems to work fine except in cases where there is a lookup in the column that I am searching.</p>
  
  <p>Basically it might return "19" and 19 corresponds to some other table value. </p>
  
  <p>It seems that the RowSource of the column is what Im after so I can do a second query to find the true value.</p>
  
  <p>Can someone point me in the right direction on finding the RowSource assuming I know the column name and then utilizing it to find the value Im after?</p>
  
  <p><strong>Edit: It seems that Im not explaining myself clearly, Here is a picture of what I trying to get programatically</strong>
  <img src="https://i.stack.imgur.com/nTY3e.jpg" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/2ok56.jpg" alt="enter image description here"></p>