title: Find record with ID
body: <p>I'm trying to move to a record that has a certain ID.</p>
  
  <p>I tried the solution on this post: <a href="https://stackoverflow.com/questions/924101/ms-access-search-for-record-by-textbox-instead-of-dropdown">MS Access search for record by textbox instead of dropdown</a></p>
  
  <p>but no success</p>
  
  <p>Here's my code</p>
  
  <pre><code>Private Sub btnShowPrevious_Click()
      Dim rs As DAO.Recordset
      Set rs = Me.RecordsetClone
      rs.FindFirst "[ID]=" &amp; ParentID
      If rs.NoMatch Then
          MsgBox "Sorry, no such record '" &amp; ParentID &amp; "' was found.", _
                 vbOKOnly + vbInformation
      Else
          Me.Recordset.Bookmark = rs.Bookmark
      End If
      rs.Close
  End Sub
  </code></pre>
  
  <p>It always hit no match but parentID = 1 and there's one record with ID = 1..</p>
  
  <p>Anyone has an idea of what is wrong?</p>
  
  <p>Thank you</p>
  
  <p>The record source is this table:</p>
  
  <pre><code>CREATE TABLE [dbo].[ProposalFollowUp](
  [ID] [int] IDENTITY(1,1) NOT NULL,
  [ProposalID] [int] NOT NULL,
  [MillID] [int] NULL,
  [ClientID] [int] NULL,
  [Comment] [nvarchar](max) NULL,
  [Method] [nvarchar](128) NULL,
  [Contact] [int] NULL,
  [ContactDate] [datetime] NULL,
  [Done] [bit] NOT NULL,
  [CreatedBy] [nvarchar](50) NULL,
  [CreatedDate] [datetime] NULL,
  [ModifiedBy] [nvarchar](50) NULL,
  [ModifiedDate] [datetime] NULL,
  [EAIEmployee] [nvarchar](50) NULL,
  [PersonInCharge] [nvarchar](50) NULL,
  [ParentID] [int] NULL,
  </code></pre>
  
  <p>here's a screenshot of the form properties</p>
  
  <p><img src="https://i.stack.imgur.com/KcXOm.png" alt="enter image description here"></p>
  
  <p>Finaly, if I show the navigation bar, I can see there's a filter.
  Probably because I open the form like this</p>
  
  <pre><code>DoCmd.OpenForm "ProposalsFollowUp", , , "[ID] = " &amp; txtID, acFormEdit, acDialog
  </code></pre>
  
  <p>If I remove the filter, it works.</p>
  
  <p>Alright
  Here's the final code</p>
  
  <pre><code>Private Sub btnShowPrevious_Click()
      Dim parent As Integer
      parent = ParentID
      Me.Filter = ""
      Dim rs As DAO.Recordset
      Set rs = Me.RecordsetClone
      rs.FindFirst "[ID]=" &amp; parent
      If rs.NoMatch Then
          MsgBox "Sorry, no such record '" &amp; parent &amp; "' was found.", _
                 vbOKOnly + vbInformation
      Else
          Me.Recordset.Bookmark = rs.Bookmark
      End If
      rs.Close
  End Sub
  </code></pre>