title: Open Form with Modal or Popup Window
body: <p>Struggling a bit with this, I have a datasheet form which lists the ID and other info for each record. So far I have found some VBA code which will open each ID as a hyperlink and pass that into another form. </p>
  
  <p>The problem I have is I wanted the form to open in a popup or modal window, my code so far is:</p>
  
  <pre><code>Private Sub ID_Click()
      Dim varWhereClause As String
      varWhereClause = "ID = " &amp; Me!ID
      DoCmd.OpenForm "Copy Of test", , , varWhereClause
  End Sub
  </code></pre>