title: Access VBA Open all records on new form, but show specified record
body: <p>I have a form with ID numbers, and buttons that are supposed to open up another form with the relating record.  In addition to that specific record being shown, i need all of the records to be opened because my form needs to have working Next and Previous buttons.  I've been trying to for a couple days now, and I haven't been able to make opening all records and showing a specific one work at the same time.  So here I've started over using the wizard to open all records.  How should I fix it so that it shows the record clicked on?</p>
  
  <pre><code>Private Sub Command74_Click()
  
  On Error GoTo Err_Go_to_Click
  
  Dim stDocName As String
  Dim stLinkCriteria As String
  
  stDocName = "Contracts"
  DoCmd.OpenForm stDocName, , , stLinkCriteria
  
  Exit_Go_to_Click:
      Exit Sub
  
  Err_Go_to_Click:
      MsgBox Err.Description
      Resume Exit_Go_to_Click
  
  
  End Sub
  </code></pre>
  
  <p>Thanks in advance!</p>