title: How to open one form or another based on parameters?
body: <p>Could someone please help me.
  This sounds simple but I'm at the point that I'm not sure if it can be done.
  The idea is: If parameters exist than open that record, else open a new one to enter data.</p>
  
  <p>This is my attempt but I can't even get it to run yet.</p>
  
  <pre><code>Private Sub Form_Load()
      If (Me.Type = Act _
          and Me.Title &lt;&gt; null _
          and section &lt;&gt; null) _
          or Me.Type in ('Proposed','Final') 
          and Me.Rule &lt;&gt; null
      Then 
          Docmd.OpenForm "F_Eval" (but open that specific f_Eval)
  
      Else
          Docmd.OpenForm "F_NewEval" (to enter new record)
      End If
  End Sub
  </code></pre>