title: VBA in Access Problem with fields being recognized
body: <p>I have a report form for labels.  It worked just fine until I tried to add a test for the presence of a "Special_Label" flag in the table.</p>
  
  <p>I coded <code>If Me.Special_Label &lt;&gt; Null then</code>  (and after typing the Sp I got the full name of the field in the dropdown and selected it).  But when I run the report I get a message #2465 "Can't find the field 'Special_Label' referred to in your expression".</p>
  
  <p>I have other "Me."fields in the code and they are printed in the label just fine.</p>
  
  <p>I added a <code>Me.RecordSource = "tblHomeOwner"</code> in the report open but that made no difference.  It was actually already in the definition of the report.</p>
  
  <p>Trying to learn more about the error, I put in another field instead of Special_Label and it was not found either.  So I am really curious why the processing of the code entry can list the fields of the table for use, but they cannot be found at run time.</p>
  
  <p>As near as I can tell there are no queries involved in this report.  I can see nothing that would restrict the fields available at run time.</p>