title: TempVars in Select Case
body: <p>I'm trying to use a <code>Select Case</code> to evaluate a <code>TempVar</code> string value, but the case is not giving me the correct result. </p>
  
  <p>My VBA Code so far:    </p>
  
  <pre><code>Private Sub Form_Load()
  
      Select Case TempVars!CurrentStatus
  
          Case Entered
              'code to disable some controls
  
          Case In Progress
              'code to disable some controls
  
          Case Ready to Approve
              'code to disable some controls
  
          Case Approved
              'code to disable some controls
  
          Case Else
              Call MsgBox("Case statement didn't catch", vbInformation, "Tempvar test for case statements")
  
      End Select
  End Sub
  </code></pre>
  
  <p>The <code>TempVar</code> is set as follows in another form:</p>
  
  <pre><code>Dim StrUserInput1 As String
  
  TempVars("CurrentStatus").Value = DLookup("Status", "Control", "Status = '" &amp; StrUserInput1 &amp; "'")
  
  'This is set by comparing the user input vs allowed status (for reports which is yet to be implemented)
  </code></pre>
  
  <p>I've tried setting the <code>Case</code> as <code>Case "Entered"</code> but it always select the first case, not the correct one. If its formatted as show above, the result is <code>Case Else</code></p>
  
  <p>Can anyone offer some insight on why or how I'm not getting the correct result?</p>