title: Access Search All Records in a Single Form
body: <p>I have a bound form in Single Form view. </p>
  
  <p>I want to mimic the behavior of the Search box in the Record Navigation Buttons, but also have more control. The problem I am facing is that when my users search for a record, sometimes they accidentally start typing over a record when it's found (say after 3 or 4 letters are entered and they are still typing the search term) and the original data gets lost. Since these fields require data entry at times, locking them isn't really an option at this point.</p>
  
  <p>My thought was to turn the Navigation Buttons off and mimic this feature through VBA or through a macro, and set the focus on another locked field when the value searched for is found (also with options to find the next one or to alert that something was, or was not found). </p>
  
  <p>I have tried working with macros and VBA already, but cannot get it work.</p>
  
  <p>I have this code (and have played with the arguments a bit), but it will only search the current record (and not all records) and either moves to the next record, or no record at all if I comment out the <code>FindNext</code> line.</p>
  
  <pre><code>Private Sub cmdFind_Click()
  
  Dim sText As String
  sText = Me.txtSearch 'a text box where user enters search term
  
  DoCmd.FindRecord sText, acAnywhere, False, acDown, True, acCurrent
  DoCmd.FindNext
  
  End Sub
  </code></pre>
  
  <p>Obviously, I am missing something. Can someone lend some insight or an alternative approach.</p>