title: Is it possible to click on a report record to open relevant form in Access using VBA
body: <p>I have a report with details of jobs/tasks, and also a form which contributes the majority of the data towards that report.  Given that a report is a nice way of looking at the larger picture of the data, and a form is the best way of editing data, I would like to be able to click on a row, and have it open up the relevant record in the form view.</p>
  
  <p>Does anyone know how to do this through VBA?  In my mind it should be possible, though my knowledge of objects in Access is limited.</p>
  
  <p><strong>Update</strong></p>
  
  <p>I've implemented the following code for my report:</p>
  
  <pre><code>Private Sub Edit_Click()
  
    Dim EntityName As String
    Dim DocName As String
  
    DocName = "Entity: Overview"
  
    strWhere = "[Entity Name]='" &amp; Entity &amp; "'"
    DoCmd.OpenForm DocName, acNormal, , EntityName
  
  End Sub
  </code></pre>
  
  <p>It successfully opens the correct form, and it also grabs the correct entity name, however it isn't filtering properly.  I can't see what the issue is with the code.</p>