title: add another lookup to statement
body: <p>I have this simple block of code on a form that looks up whether or not a part number exists before the order can be entered. It displays either a green check mark if it does or a red X if it doesn't. I would like to add a lookup to make sure the part number is not obsolete (true/false) as well. but I'm not sure what I need to do.</p>
  <p>'Here is the code</p>
  <pre><code>Private Sub txtPN1_LostFocus()
  If Not IsNull(txtPN1) Then
      If DCount(&quot;[PartNum]&quot;, &quot;[PartsFinished]&quot;, &quot;[PartNum] = '&quot; &amp; txtPN1 &amp; &quot;'&quot;) &gt; 0 Then
          pic1.Picture = &quot;\\TORQSERVER\Torq\Shawn\check.png&quot;
      Else:
          pic1.Picture = &quot;\\TORQSERVER\Torq\Shawn\cross.jpg&quot;
      End If
  End If
  End Sub
  </code></pre>