title: Check if unbound text box is equal to a string
body: <p>In an access form, I have an unbound text box when contains a formula. The formula returns "Yes" or "No" based on whether the form has been completed (it ensure that all required boxes are filled in).</p>
  
  <p>On the same form, I have a command button which I want to use to filter out completed forms. Basically, it is a button that save "Save Record" and when clicked, the form - if completed - should disappear (i.e. be filtered out).</p>
  
  <p>Below is what I put in, but I don't know VBA.</p>
  
  <pre><code>Private Sub bttn_Save_Click()
      Me.Filter = Me.MainFormComplete = Yes
      Me.FilterOn = True
  End Sub
  </code></pre>
  
  <p>How do I get check to see if my field (MainFormComplete) is equal to "Yes"?</p>