title: Access 2007 Search Button
body: <p>I'm having trouble trying to get this to work for me, I have a inputbox to locate an account number in my table, but i want it to continue to keep locating that account number as my table with have more than one line with the same account number. This is what i currently have but I cant figure out how to do a find next record with the same account number.</p>
  
  <pre><code>Dim strAccount As String
  Dim rstQA As Recordset
  
  strAccount = InputBox("Enter Account Number")
  
  If strAccount = "" Then Exit Sub
  Set rstQA = Me.Recordset.Clone
  rstQA.FindFirst "[Account Number]='" &amp; strAccount &amp; "'"
  If rstQA.NoMatch Then
      MsgBox "No record of account"
  Else
  Me.Bookmark = rstQA.Bookmark
  End If
  
  rstQA.Close
  Set rstQA = Nothing
  </code></pre>